Write a query to find second highest salary of an employee.
Answer Posted / mubin ahmad
select salary from employee e1 where 2=(select count(*)
from employee e2 where e2.salary>=e1.salary)
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are local and global Indexes and where they are useful.
What is a record in pl/sql?
Which is better join or inner query?
Can we create a trigger on view?
Is oracle sql free?
What are the three forms of normalization?
what happens if you no create privilege in a database? : Sql dba
What is file based approach?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
Can we use update in sql function?
what is cursor. write example of it. What are the attributes of cursor.
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What are sql objects?
What are instead of triggers?
What do we need to check in database testing?