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
- 20780 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / neelu
select max(salary) from employees where rownum<= 2
order by salary desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain about temporary stored procedure?
List out the difference between union and union all in sql server?
Does a server store data?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What is difference between foreign key and unique key?
What is partitioned view?
What do you understand by triggers?
How to find tables without indexes?
Can you please differentiate between a primary key and a unique key?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
What is the report builder?
How can we migrate from SQL server to SQL Azure?
What is sqlcmd?
What do you mean by data integrity?
Do you know what is fill factor and pad index?
