How to find out the second largest element from mysql table
- 15 Answers
- 24864 Views
- I also Faced
- E-Mail Answers
Answer Posted / nikhil mishra
SELECT Salary FROM tablename order by Salary desc limit 1,1
| Is This Answer Correct ? | 24 Yes | 11 No |
Post New Answer View All Answers
HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE
How to create and drop view in mysql?
What does innodb stand for?
What is difference between group by and order by clause?
Write a query to create a database and a table?
Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?
What mysql means?
How can we find out which auto increment was assigned on Last insert?
How do you say mysql?
How do you concatenate strings in mysql?
What is blob in mysql?
What is the use of mysql_close()?
How can I see connections in mysql?
How to represent ENUMs and SETs internally?
Why do we use views instead of tables?
