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

sql query for second highest salary in oracle

select *from emp a where 2=(select count (distinct(b.sal))from emp b where a.sal<=b.sal);


EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
7788 SCOTT ANALYST 7566 19-APR-87 3000 20


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