User Id :    Password :      New Member   Forgot Password  
Topic: Find top salary among two tables (table1,table2) ?
Anamika singh
11 Oct 2010 at 03:18 AM
Find top salary among two tables (table1,table2) ?
Re: Find top salary among two tables (table1,table2) ?
Gaurav
12 Oct 2010 at 03:07 AM
SELECT TOP 1 sal FROM (SELECT MAX(sal) AS sal FROM table1 UNION SELECT MAX(sal) AS sal FROM table2) a ORDER BY sal DESC
Total Replies: 1
 
Featured Text Ad

Featured Ad