Dashboard > GreenPepperOpen > ... > Database > Query order is irrelevant
  GreenPepperOpen Log In View a printable version of the current page.  
  Query order is irrelevant
 Browse Space
Added by Francois Denommee, last edited by Francois Denommee on Jan 27, 2010
Labels: 
(None)

Query does not presume order, that is left to the interpreter to sort out.

database-connection

connect to MySql database on localhost with username dbgreenpepper and password dbgreenpepper and database dbgreenpepper

set of query   select n from ( select 1 as n union select 2 union select 3) x
n
3
1
2

DEMONSTRATION LICENSE - This Confluence site is for demonstration purposes only. Evaluate Confluence today.
Powered by Atlassian Confluence, the Enterprise Wiki. (Version: 2.4.3 Build:#705 Mar 21, 2007) - Bug/feature request - Contact Administrators