Given an employee table, how would you find out the second
highest salary?
Answer Posted / balindra sahani
select max(sal) from emp
where sal not in (select max(sal) from emp order by sal desc )
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the 18 schemas?
What are the key features of dbms?
What are the types of database model?
What are the constraints on severity level in raiseerror?
How to generate OIDS
What is the maximum length of an extended property?
Can an extended stored procedure be called from inside a user-defined function?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
Explain about the storage and physical database design?
Explain about relational operator join?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
Which four data types cannot be used as a return type from a user-defined function?
What is dbms and its application?
How can I detect whether a given connection is blocked?
What is the database development process?