Select Top records in SQL- part 4

  In this blog we are going to find out the highest salary in customer table.

Select Top:

• The SELECT TOP clause is used to specify the number of records to return. 
• The SELECT TOP clause is useful on large tables with thousands of records, returning a large number of records can impact performance.

create a new table for solving the following query:

Customer Table:

                 

1.Finding the First highest sales in customer table?

                  

                       

2.Finding the Second highest sales in customer table?

                  

3.Finding the third highest sales in customer table?

                       

               

4.Finding the fourth highest sales in customer table?

                       

For more understanding watch below video :

https://youtu.be/uGlfP9o7kmY

Thank you!!!!