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
- 60236 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / prathapshankarshiva
select max(salary) from (select salary from table1 where
salary<(select max(salary) from table1))
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain primary key, foreign key and unique key?
where the connection string store in the database
How does index makes search faster?
What is DCL?
Can we use trigger new in before insert?
What is an etl file?
What is table constraint?
What is meant by dirty read?
What do you understand by recursive stored procedure?
Explain what stored procedure sp_replcounters is used for? : sql server replication
What is normalization? Describe its different types.
What are cursors and when they are useful?
How to maintain a fill factor in existing indexes?
Can you pass expressions to stored procedure parameters?
What are pages and extents? : SQL Server Architecture
