johnkainn
asked on
Union top 1
I am using union, like.
SELECT Id, StartDate From TableA
UNION
SELECT Id, StartDate From TableB
I would like to get top 1 ordered by StartDate. How is best to do this when I use Union?
SELECT Id, StartDate From TableA
UNION
SELECT Id, StartDate From TableB
I would like to get top 1 ordered by StartDate. How is best to do this when I use Union?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.