Interested to Buy Any Domain ? << Click Here >> for more details...
1. How to fetch all the duplicate records from the table.
2. How to fetch the second highest salary from the table.
- 12 Answers
- 20791 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / oracle.hemant
select max(salary) from emp where salary<(select max(salary)
from emp)
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to backup SQL Server Reporting Services ?
How to select all columns of all rows from a table with a select statement in ms sql server?
Can I disable or restrict ssrs export formats (rendering formats)?
What is resultset concur_updatable?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
Tell me extended events in sql server 2008?
What is the difference between char, varchar and nvarchar?
What is policy based management (pbm)? : sql server database administration
What are the disadvantages of using the stored procedures?
What is enhanced database mirroring in sql server 2008?
How to remove duplicate rows from table?
what are the critical issues you have resloved in your company
What is sub query and its properties?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
what are the Prerequisites for Replication?
