How To Find Second Max Element From Database ?

1.	How To Find Second Max Element From Database ?
Answer» RAILS Query:Model.order("yourField DESC").LIMIT(1).offset(1) Mysql: SELECT * FROM yourTable ORDER BY yourField DESC LIMIT 1,1; Other sql ways: -select MAX(column_name) from table_name where column_name<(select max(column_name) from table_name) -SELECT NAME FROM Employees group BY Salary DESCENDING limit 2; Rails Query:Model.order("yourField DESC").limit(1).offset(1) Mysql: SELECT * FROM yourTable ORDER BY yourField DESC LIMIT 1,1; Other sql ways: -select max(column_name) from table_name where column_name<(select max(column_name) from table_name) -SELECT Name FROM Employees group BY Salary DESCENDING limit 2;

Answer»

RAILS Query:Model.order("yourField DESC").LIMIT(1).offset(1)

Mysql: SELECT * FROM yourTable ORDER BY yourField DESC LIMIT 1,1;

Other sql ways: -select MAX(column_name) from table_name where column_name<(select max(column_name) from table_name)

-SELECT NAME FROM Employees group BY Salary DESCENDING limit 2;

Rails Query:Model.order("yourField DESC").limit(1).offset(1)

Mysql: SELECT * FROM yourTable ORDER BY yourField DESC LIMIT 1,1;

Other sql ways: -select max(column_name) from table_name where column_name<(select max(column_name) from table_name)

-SELECT Name FROM Employees group BY Salary DESCENDING limit 2;

Discussion