JohnHC

JohnHC has asked 4 questions and find answers to 14 problems.

Stats

About

Contract SQL and BI dev with experience in all flavours of SQL and a history of fixing far-too-large spreadsheet with a speciality in utilities and telcos.

JohnHC questions

NameError: name is not defined error in class __init__() method
SSRS not showing all rows by level (hierarchy)
Retrieve data from web service with ws addressing

JohnHC answers

Oracle SYSDATE format Change
Put many columns in group by clause in Oracle SQL
Start and end time of a query
Random records in Oracle table based on conditions
SQL Query -- how to find lowest 2 numbers
Limit LISTAGG results in Oracle
Grant privileges for an Oracle package?
BigQuery SQL WHERE Date Between Current Date and -15 Days
How to reference multiple columns in case statement
SQL Select birthdays in specific date range