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
- 20168 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / anbarasan k kanagaraj
select salary from user order by salary desc LIMIT 1, 1
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Which sql server table is used to hold the stored procedure scripts?
What are the steps you should follow to start sql server in single-user mode?
In what version of sql server were synonyms released?
Explain about Joins?
Can you roll back the ddl statement in a trigger?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
What are the properties of the relational tables?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
What is difference between commit and rollback when used in transactions?
Do you think BCNF is better than 2NF & 3NF? Why?
What are sql server functions?
What is 4nf in normalization form?
How to read data in a table with "select" statements?
How to make a column nullable?
How to write a query with an inner join in ms sql server?
