SQL Practice commands

 

 

 

Display the highest salary 

  • Select max(salary) from employee
  • Select salary from employee order by salary desc limit 1
  • select top1 salary from employee order by salary desc

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Leave a Comment

Your email address will not be published. Required fields are marked *