how to find nth highest salary
Answer Posted / divya
Select Salary
From Employee
Where rowid = n
Order By Salary Desc;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the differences between char and nchar in ms sql server?
How to download and install microsoft sql server management studio express?
What are the instances when triggers are appropriate?
What are dml triggers and types of dml triggers?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
How do I make a resultset scrollable?
Explain can you implement data mining in ssrs?
What is auditing in sql server?
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?
Data table as parameter in sql server?
Do you know what is a trace frag? Where do we use it?
Explain mixed authentication mode of sql server?
What do you need to connect php to sql server?
What is the use of sql profiler in sql server 2012?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?