Write an sql query to sort a table according to the amounts in a row and find the second largest amount.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

How to create a new table in a given schema?

0 Answers  


Explain syntax for dropping triggers?

0 Answers  


What is Schema? and why we use schemas?

4 Answers  


from the table display the 2nd highest salary? and also the least 2nd salay?

8 Answers  


How do you use a subquery to find records that exist in one table and do not exist in another?

0 Answers  






wht is normalization?can u explain me in detail?

9 Answers   TCS,


Find first and last day of current month in sql server

0 Answers  


What are a scheduled jobs or what is a scheduled tasks?

0 Answers  


What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,


What is #temp and @table variable in SQL server?

0 Answers  


Disadvantages of the indexes?

0 Answers  


What is single-user mode?

0 Answers  


Categories