how to calcuate the second highest salary of he employee

Answer Posted / vivek ghorad

select min(select top(2)salary from emp)from emp;

Is This Answer Correct ?    3 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the various restrictions imposed on view in terms of dml?

522


what is union? : Sql dba

582


What kind of join is join?

559


What is trigger in sql and its types?

536


Can dml statements be used in pl/sql?

579






What are basic techniques of indexing?

846


What are the types of dbms?

545


what are the types of subquery? : Sql dba

590


What is the benefit of foreign key?

528


What does desc stand for?

593


Explain what is a database?

652


How to start the command-line sql*plus?

566


What is pl/sql table? Why is it used?

561


what are the non-standard sql commands supported by 'mysql'? : Sql dba

573


What is a variable in sql?

514