Lamak questions

Lamak answers

• SELECT specific rows when using GROUP BY
• Group rows into sets of 5
• Right Substring Statement SQL
• How to use calculated field in another field of the same query
• How can I use SQL to get a variable value from a literal?
• SQL: query one column in same table
• Concatenate the result of an ordered String_Split in a variable
• Workaround for outer join with an IN operator in Oracle
• fetch most recent non null record
• SQL Server sum of float should give value of 1 but filter says otherwise