List:General Discussion« Previous MessageNext Message »
From:Rhino Date:April 7 2006 2:53pm
Subject:Re: A doubt in SELECT query
View as plain text  
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" <subramani95@stripped>
To: <mysql@stripped>
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/mysql?unsub=1


-- 
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

Thread
A doubt in SELECT querysubramani7 Apr
  • Re: A doubt in SELECT queryBarry7 Apr
  • Re: A doubt in SELECT queryRhino7 Apr