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
What are the various restrictions imposed on view in terms of dml?
what is union? : Sql dba
What kind of join is join?
What is trigger in sql and its types?
Can dml statements be used in pl/sql?
What are basic techniques of indexing?
What are the types of dbms?
what are the types of subquery? : Sql dba
What is the benefit of foreign key?
What does desc stand for?
Explain what is a database?
How to start the command-line sql*plus?
What is pl/sql table? Why is it used?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
What is a variable in sql?