Top Answers

1. Pattern matching in Postgres SELECT query
   2 votes
2. Unable to ALIAS a simple CASE statement
   2 votes
3. MySQL query to select a record from each group that meets a user-defined criterion
   1 votes
4. Calculate percentages of count in SQL relative to the category
   1 votes
5. Filter out certain XML nodes and form another XML with these nodes and their ancestors and child nodes
   1 votes