Interested to Buy Any Domain ? << Click Here >> for more details...
write query for fourth maximum salary from employee table
- 14 Answers
- 24496 Views
- Mind Tree, SP Software, I also Faced
- E-Mail Answers
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
What is the cartesian product of the table?
What is normalization? What number of normalization shapes are there?
What is code near application topology?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What are transactions in sql?
How to create a ddl trigger using "create trigger" statements?
How to write character string constants or literals in ms sql server?
Will sql server 2005 allow you to reduce the size of a column?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
Can group functions be used in the order by clause in ms sql server?
How much does sql server 2016 cost?
How do we synchronize On-Premise SQL server with SQL Azure?
How you can find out if an index is useful to the optimizer?
What is a trigger in sql server?
How do I start sql server 2017?
