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
- 58848 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / neon
select salary from emp
where salary = (select max(salary) from emp
where salary <>(select max(salary) from emp)
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
Can we use pragma autonomous_transaction in trigger?
Explain about merge replications?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
What are the benefits and tasks of object explorer? : sql server management studio
What is subreport?
What is scrollable cursor?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
Can we add an identity column to decimal datatype?
What are the new features are introduced in sql server 2012 reporting services?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
How to execute the cursor queries with "open" statements?
what is a deadlock? : Sql server database administration
How to list all user names in a database?
How to throw custom exception in Stored Procedure?
Why use update_statistics command in sql server?
