Share the knowledge! Educate universe!
--Second maximum column valueSELECT *FROM customersORDER BY age DESC, first_name ASCLIMIT 1,1; -- 1 - number of row to omit, 1 - no of records to show
--Second maximum column value
SELECT *
FROM customers
ORDER BY age DESC, first_name ASC
LIMIT 1,1; -- 1 - number of row to omit, 1 - no of records to show
SOLID Principles S – Single Responsibility Principle There should never be more than one reason for a class to change. O – Open-Closed Prin...
No comments:
Post a Comment