how to check the 3rd max salary from an employee table?
Answer Posted / venkateswarulu.s
select min(salary) from emp where salary in(select distinct
top 3 salary from
emp order by salary desc)
| Is This Answer Correct ? | 13 Yes | 10 No |
Post New Answer View All Answers
How to execute a stored procedure?
What is recursive join in sql?
What program will open a mdb file?
What is database sql?
How do you break a loop in pl sql?
how to select first 5 records from a table? : Sql dba
How is data stored in sql?
Is coalesce faster than isnull?
Write a sql query to get the third highest salary of an employee from employee_table?
what is denormalization. : Sql dba
How to add new employee details in an employee_details table with the following details
What are all the different normalizations?
What is dense_rank in sql?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
How to move files from one directory to another in pl sql?