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
Can I join the same table twice?
What is inner join in sql?
How do I remove all records from a table?
What is meant by user defined function?
What are the different types of triggers?
Explain the purpose of %type and %rowtype data types?
What are the types of dbms?
Is primary key an index?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
what is a constraint? : Sql dba
Define SQL and state the differences between SQL and other conventional programming Languages?
Determine if oracle date is on a weekend?
What is pl sql block structure?
What is the difference between the conventional and direct path loader? : aql loader
What is basic structure of pl sql?