Fahmi questions

Fahmi answers

• How to return multiple row value as a single row with multiple column using sql
• SQL Order By with case when
• How to select two different values from a table with different conditions in mysql?
• Mysql: rows having minimum value and prioritize where condition based on case
• Join two tables with group by condition
• GROUP BY and take the given value if it is not empty
• How to get everything before the last occurrence of a character in MySQL?
• how to select only by date from timestamp column in postgres?
• Looping through Distinct values in SQL, and using the distinct values in subquery
• Alternatives of array_agg() or string_agg() on redshift