SELECT salary FROM employees ORDER BY salary DESC LIMIT 2,1

How to find out the second largest element from mysql table

Question Posted / harish varma

Answer Posted / harish varma

SELECT salary
FROM employees
ORDER BY salary DESC
LIMIT 2,1

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we create table in stored procedure?

964

Is mysql is a programming language?

1004

Write a query to count the number of rows of a table in mysql.

938

What is 'mysqld'?

956

What is csv?

953

How can you calculate the sum of any column of a table?

1048

What is difference between mysql and mysqli?

926

Write a query to create a database and a table?

912

Write a query to display even rows in student table using mysql?

903

What is mysql vs sql?

991

What does mysql flush tables do?

973

How to decrement dates by 1 in mysql?

1015

Can mysql handle billions of records?

1073

Can python connect to mysql?

1024

What is maximum table size in mysql?

953