« The Quickest Way To Count Users Online With PHP
sleep & usleep »

Problem Of Order by In Union

Problem Of Order by In Union

If we Use order by in single select query, It display the result according to the order by filed.
For Example,
SELECT * FROM table1 ORDER BY field1

If we use order by in union of select statement without limit it will have no effect.

Example:
SELECT * FROM table1 ORDER BY field1
UNION
SELECT * FROM table2 ORDER BY field1
UNION
SELECT * FROM table3 ORDER BY field1

This entry was posted on Friday, January 19th, 2007 at 5:02 pm and is filed under mysql database development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.

All material @ copyrighted by chrisranjana.com. If you want to link to this article you are welcome to do so. Unauthorized publication is strictly prohibited. This developer tutorial website contains articles by Php programmers , Software developers, Mysql programmers and asp c# programmers. This website also contains ajax tutorials and advanced mysql sql stored procedures and functions tutorials and sample codes.