Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
- 35 Answers
- 60245 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / sridhar
select gross_pay from tbl_payroll where gross_pay != (select
max(gross_pay) from tbl_payroll) limit 0,3
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
Explain what is the function of sql server agent windows service?
How do I create a stored procedure in dbml?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What are data regions?
What are different replication agents and what's their purpose? : sql server replication
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.
What are the types of sql server?
Why should you use or avoid select * statements?
What are the 2 types of classifications of constraints in the sql server?
How to implement service broker?
Difference between report and query parameter.
What are dml (data manipulation language) statements in ms sql server?
How to find table changes in sql server?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
