SQL Query To Find Maximum Salary From Emp Table in SQLSERVER.

Check here to find 2nd and 3rd Highest salary

sql query to get first highest salary from emp table


Syntax:select max(columnname)as MAX_SAL from tablename


Ex:select max(sal)as MAX_SAL from emp


Check this post to get 2nd and 3rd Highest salary
SQL Query to copy only structure of one table to other table in SqlServer
SQL Query to get structure of table in SqlServer
Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs