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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment