Given an employee table, how would you find out the second
highest salary?
Answer Posted / sowjanya
Select * from emp where sal=(select Max(sal) from emp where
sal<(select Max(Sal) from emp)
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How to use online Backups?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
Explain about network model?
How can I detect whether a given connection is blocked?
Explain about relational database management systems?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
Explain the role of indexing in databases?
What are the key features of dbms?
What are the types of database model?
State the acid rules?
What are the three types of database design?
What is a database development?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
What are data modelling techniques?