how to calcuate the second highest salary of he employee
Answer Posted / udhayakumar
select salary from (select salary from emp order by salary
desc) where rownum=2;
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is trigger explain with example?
give the syntax of grant and revoke commands? : Sql dba
When should I use nosql database?
Are subqueries better than joins?
What are the 3 types of behavioral triggers?
Is sql developer case sensitive?
How do I write a sql query in pgadmin 4?
What is rename in sql?
Why are sql stored procedures used?
what is the difference between a local and a global temporary table? : Sql dba
what is the difference between $message and $$message? : Sql dba
How to get each name only once from an employee table?
What is break?
Is inner join faster than left join?
Which one is better subquery or joins?