radar questions

radar answers

• PostgreSQL, SELECT CASE COALESCE
• Alternative to GROUP BY
• How to find referenced records of parent in informix
• How to shrink a log file without backuping first?
• Find duplicate records in large table on multiple columns the right way
• sql select min, return value from different column in same row with grouping
• using LIKE %% with LEFT JOIN
• Limit a LEFT JOIN Subquery to 1 result
• C: Sorting Big Data; Not in Memory
• Converting 1 record with a start and end date into multiple records for each day