Home » RDBMS Server » Server Administration » Re: Sorting the results of a unique query
Re: Sorting the results of a unique query [message #372922] Sun, 18 March 2001 22:18
Thirumalai and Prakash
Messages: 23
Registered: March 2001
Junior Member
Hi jimmy,
You can try this,

SELECT * FROM
((SELECT *
FROM table1
WHERE price < 20) UNION
(SELECT *
FROM table2
WHERE price < 20)) ORDER BY columnname;

Regards
S.Thirumalai

Report message to a moderator

Previous Topic: Index
Next Topic: SQL3
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jun 30 01:03:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.