Re: ORDER BY 1

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Sat, 03 Aug 2002 05:49:05 GMT
Message-ID: <l9K29.767274$cQ3.117571@sccrnsc01>

It means the first column of the select. eg select count(*), dept from emplyee group by dept order by 1; So that the results will be sorted on the result of the count(*) Jim
"Stjepan Brbot" <stjepan.brbot_at_zg.hinet.hr> wrote in message news:aifov1$3c8u$1_at_as201.hinet.hr...
> What kind of ordering it is when there is "ORDER BY 1" in SELECT
> SQL-statement?
>
> --
>
> Stjepan Brbot
>
>
>
Received on Sat Aug 03 2002 - 00:49:05 CDT