David Faber questions

David Faber answers

• SQL SUM(QTY) but only for records where QTY > 0
• How to return column that matched the query in Solr..?
• substring, after last occurrence of character?
• What do I need to do to make a field in SOLR sortable?
• Find which character occurs the greatest number of times in a string
• select rows having time difference less than 2 hour of a single column
• Orace: Default column value based on a filter
• How to Dense Rank Sets of data
• Handling exception in Oracle
• Oracle - need to extract text between given strings