Interested to Buy Any Domain ? << Click Here >> for more details...
write query for fourth maximum salary from employee table
- 14 Answers
- 24860 Views
- Mind Tree, SP Software, I also Faced
- E-Mail Answers
Answer Posted / prabhjeet singh sethi
select * from
(select rank(salary) over (partition by employee order by salary desc) as top_salary, employee from table
group by employee)
where top_salary = 4
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the disadvantages of cursors? : Sql server database administration
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
What do you understand by recursive stored procedure?
Where are stored procedures in sql server?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
What are the various editions of sql server 2017 that are available in the market?
What is the difference between for trigger and after trigger?
what is normalization? : Sql server database administration
What is BCNF? How is it better than 2NF & 3NF?
What is a dataset and what are the different types of datasets?
What happens if we shrink log file in sql server?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
List the different types of collation sensitivities in sql server?
How do you set a trace flag in sql server?
Write a SQL query in order to merge two different columns into single column?
