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

What is blocking and how would you troubleshoot it?

2 Answers  


How can a database be repaired?

0 Answers  


How to change the name of a database user?

0 Answers  


What happens if null values are involved in string operations?

0 Answers  


What are different types of views?

0 Answers  






you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 Answers  


What r sql reporting services and analysis services? how can we use it.

2 Answers   Microsoft,


What is the default server name for sql server?

0 Answers  


What is an identity column in insert statements?

0 Answers  


Explain subquery and state its properties?

0 Answers  


What is the difference between system objects and user objects?

0 Answers   HCL,


What is BCNF? How is it better than 2NF & 3NF?

0 Answers   Essar,


Categories