how to find the second highest salary from emp table?
Answer Posted / tarun
SELECT salary FROM tb_salary ORDER BY salary DESC LIMIT 2,1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are enums used for in mysql? : Sql dba
How do you define a foreign key?
How can you load multi line records? : aql loader
Are views faster than queries?
What are different types of queries in sql?
Which table is left in left join?
Is it possible to link two groups inside a cross products after the cross products group has been created?
What are triggers and its types?
How to write a query to show the details of a student from students table whose
What are the events on which a database trigger can be based?
How many sql core licenses do I need?
What is right join in sql?
Why we use cross join?
What are field types?
What is a primary key called that is made up of more than one field?