how to find the second highest salary from emp table?
Answer Posted / nirjesh pandey
select salary from employee order by salary DESC LIMIT(1,1);
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Which is faster subquery or join?
What is mutating error in pl sql?
Does sql full backup truncate logs?
What is sql and its types?
explain advantages of innodb over myisam. : Sql dba
What is benefit of creating memory optimized table?
What is dml with example?
How many types of primary keys are there?
Why procedure is used in sql?
Can primary key be changed?
What is sql injection owasp?
What are % type and % rowtype?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
How do I add a database to sql?
Explain scalar functions in sql?