JohnHC

JohnHC has asked 4 questions and find answers to 12 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

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
How to delete oldest week(period) in MS SQL database?
How can I determine the start and end activities in a dataset?