how to find 2nd highest salary in random database salary of employer.....

Answer Posted / arnab das

select distinct column_name from table_name order by
column_name desc limit 1,1

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain GROUPBY & HAVING clause with examples.

1828


How to show all records starting with the letters 'sonia' and the phone number '9876543210'

511


What is a simple query?

465


How to return query output in xml format?

590


What is localhost in mysql?

528






How do I start mysql in ubuntu?

476


When to use order by in delete statement?

563


What are the functions of mysql?

458


What are the differences between char and nchar?

527


How many rows can be inserted in mysql at a time?

495


How do I stop a query in mysql workbench?

477


What is the usage of "i-am-a-dummy" flag in mysql?

665


How to create trigger in mysql workbench?

539


What is difference between mysql and mysqli?

480


Can mongodb replace mysql?

523