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
explain GROUPBY & HAVING clause with examples.
How to show all records starting with the letters 'sonia' and the phone number '9876543210'
What is a simple query?
How to return query output in xml format?
What is localhost in mysql?
How do I start mysql in ubuntu?
When to use order by in delete statement?
What are the functions of mysql?
What are the differences between char and nchar?
How many rows can be inserted in mysql at a time?
How do I stop a query in mysql workbench?
What is the usage of "i-am-a-dummy" flag in mysql?
How to create trigger in mysql workbench?
What is difference between mysql and mysqli?
Can mongodb replace mysql?