write query for fourth maximum salary from employee table
Answer Posted / pramod
Select Top 1 (Salary) from emp where salary not in
(select Top 3 (Salary) from emp order by salary desc)
order by salary desc
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
how would you improve etl (extract, transform, load) throughput?
Which database stores information about replication?
What are subquery and its properties?
How to get a list of columns using the "sys.columns" view in ms sql server?
What is sql server locking?
How to convert character strings into numeric values?
Is sql server 2016 free?
What are the kinds of subquery?
You want to implement the one-to-one relationship while designing tables. How would you do it?
Can group by and orderby be used together?
How to get the definition of a stored procedure back?
What do you mean by an execution plan? How would you view it?
Tell me what are the essential components of sql server service broker?
Can we insert data into a view?
What are click through reports?