1. How to fetch all the duplicate records from the table.
2. How to fetch the second highest salary from the table.
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 data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
What is the most common trace flags used with sql server?
why would you call update statistics? : Sql server database administration
What is the default sql server instance name?
What do you mean by subquery?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What are the advantages of sql azure?
What are the steps to insert a table?
What are a scheduled jobs or what is a scheduled tasks?
What is a rownum?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
Explain what is the difference between a local and a global temporary table?
What is the index requirement in SQL Azure?
What do you understand by sql server agent?
When we should use @@error?