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

No comments:

Recent Posts