Interested to Buy Any Domain ? << Click Here >> for more details...
To find second largest salary in Employee table
- 17 Answers
- 20392 Views
- CSS, I also Faced
- E-Mail Answers
Answer Posted / anil
select max(salary) from tbl_employee where salay <(select max(salary) from tbl_employee)
| Is This Answer Correct ? | 30 Yes | 6 No |
Post New Answer View All Answers
what is dbcc? : Sql server database administration
Define master database?
What are the new features are introduced in sql server 2012 reporting services?
Explain transaction server consistency?
What is the maximum row of a size?
what's the information that can be stored inside a bit column? : Sql server database administration
Can you explain the disadvantages/limitation of the cursor?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
How to find the version of sql server? : sql server database administration
What are the advantages of stored procedure in sql server?
How to disable triggers using "disable trigger"?
What is meant by referential integrity?
What are trace files?
What are the differences between web role and worker role?
What is intellisense?
