SQL kingdom X @sqldiscussions, Twitter Profile

2 years ago

Given a table 'sales' with date and revenue columns, write sql query to find the date when revenue was 2nd highest. #SQLchallenge #SQL

2 years ago

@sqldiscussions SELECT DATE, MAX(REVENEU) FROM SALES WHERE REVENUE <> (SELECT MAX(REVENUE) FROM SALES) GROUP BY DATE;