how to find the second highest salary from emp table?
Answer Posted / hima
select sal from emp order by salary desc limit 1,1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What type of join is sql join?
Can we write ddl statements in functions?
What is scalar and vector?
How do you update a table in sql?
What do you mean by query optimization?
Which kind of parameters cannot have a default value in pl sql?
What is trigger in sql?
How do I partition a table in sql?
How do I enable sql encryption?
Which sql most popular?
When is a declare statement required?
What are the different types of a subquery?
What is a sql instance vs database?
Can you selectively load only those records that you need? : aql loader
What is the difference between Union and Union all. Which is faster.