Interested to Buy Any Domain ? << Click Here >> for more details...
To find second largest salary in Employee table
- 17 Answers
- 19773 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 difference between inner join and join?
Does server sql treat char as a variable-length or fixed-length column?
How to manipulate data from one table to another table ?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
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 acid properties? : Sql server database administration
Which tcp/ip port does sql server run on? How can it be changed?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
Define Business Edition in SQL Azure?
What are the types of indexes?
What are locks in sql?
Explain filtered indexes benefits?
What are page splits? : SQL Server Architecture
What is the recommended total size of your memory optimized tables?
