If the sequence in which the result set is displayed is important to you,
you will need to use SQL clauses to force the sequence you want. ORDER BY is
the main way of accomplishing this although other clauses, like GROUP BY and
DISTINCT, can also affect the sequence. But ORDER BY is the normal method of
forcing the output to be in a specific order.
--
Rhino
----- Original Message -----
From: "subramani" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Friday, April 07, 2006 10:22 AM
Subject: A doubt in SELECT query
hello all,
In which order the datas are displayed, when the SELECT quey is used ?
Is it random or the order in which the datas are inserted?
-- r.subramani
My log file: http://subramanitce.blogspot.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.3.5/303 - Release Date: 06/04/2006
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.3.5/303 - Release Date: 06/04/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
