how to find nth highest salary
- 103 Answers
- 163913 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
Answer Posted / ajay kumar barik
select a.id from product a where (1= (select count(b.id)
from product b where b.id>=a.id))
It is for all database
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
What are “lock” hints?
How to find the list of fixed hard drive and free space on server?
Describe in brief sql server monitoring ways.
How fixed length strings are truncated and padded?
Can the query output be sorted by multiple columns in ms sql server?
What are recommended options to be used while using db mirroring? : sql server database administration
How to loop through returning rows?
What is an index. What are the types?
What are the different sql server versions?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What are 3 ways to get a count of the number of records in a table?
What is CTE in SQL
Explain triggers?
Explain sql server service broker?
