SQL SERVER Finding nth Highest Value

SQL SERVER Finding nth Highest Value


--Select 4th Highest Salary (1-way)

SELECT TOP 1 E_ID FROM (SELECT DISTINCT TOP 4 E_ID FROM EMP ORDER BY E_ID DESC)A ORDER BY E_ID ASC


--Select 4th Highest Salary (2-way)

SELECT MIN(E_ID) FROM (SELECT TOP 4 E_ID FROM EMP ORDER BY E_ID DESC)E




Description:-

This is one of the best query that I posted ,when I got an interesting question regarding this.Use of sub-queries makes complex perforemance.




download file now

Comments

Post a Comment

Popular posts from this blog

Spider Man Friend Or Foe ISO Free Download PPSSPP Setting

Image
Spider Man Friend Or Foe ISO Free Download PPSSPP Setting Inspired by the Spider-Man film trilogy and the classic Spider-Man comics, Spider-Man: Friend or Foe challenges players to defeat and then join forces with notorious movie nemeses including Doc Ock, Green Goblin, Venom and Sandman, and embark on an epic quest to overcome a worldwide evil threat. Throughout the games original story and thrilling battles, fans control Spider-Man and one of numerous Super Hero or Super Villain sidekicks and master unique fighting moves and styles while switching between characters to execute team combos and defeat foes. � IGN Screen Shots File Name: Spider Man Friend Or Foe Publisher: Activision Developer: A2M (Artificial Mind and Movement) Genre: Action Image Format: ISO File Size: 552 MB Best PPSSPP Setting Of   Spider Man Friend Or Foe Gold Version.1.3.0.1 wait for 5 seconds & click the skip ad You may click the link below to download your file Download Inst...
Read more

Sorry Mutter closed unexpectedly on Ubuntu 10 10

Image
Sorry Mutter closed unexpectedly on Ubuntu 10 10 I am just exploring and understanding various features on Ubuntu 10.10 netbook. I install it on a usb stick and running from it. I am not sure what cause this problem. But I think after closing a window suddenly a message appear and says Sorry, Mutter closed unexpectedly This message box also include a request. It say If you were not doing anything confidential (entering passwords or other private information, you can help to improve the application by reporting the problem. Mutter is a window manager for ubuntu netbook edition. I am not sure why it happened. Is it a bug? download file now
Read more

Solution Ubuntu 10 04 minimize maximize and close button to right

Image
Solution Ubuntu 10 04 minimize maximize and close button to right One of the more controversial changes in the Ubuntu 10.04 is the Mac OS-inspired change to have window buttons on the left side. We�ll show you how to move the buttons back to the right. Before While the change may or may not persist through to the April 29 release of Ubuntu 10.04, in the beta version the maximize, minimize, and close buttons appear in the top left of a window. How to move the window buttons The window button locations are dictated by a configuration file. We�ll use the graphical program gconf-editor to change this configuration file. Press Alt+F2 to bring up the Run Application dialog box, enter �gconf-editor� in the text field, and click on Run. The Configuration Editor should pop up. The key that we want to edit is in apps/metacity/general. Click on the + button next to the �apps� folder, then beside �metacity� in the list of folders expanded for apps, and then click on the �general� folder. The butto...
Read more