Re: Need SQL guru's help: Best query?

From: Gerard H. Pille <ghp_at_infosoft.be>
Date: 1996/03/23
Message-ID: <4j11qu$kfu_at_news.Belgium.EU.net>#1/1

In article <4iv6eq$ot9_at_iserv.dnt.dialog.com>, Charles Dye PC (cdye_at_dnt.dialog.com) says...
!>
!>Donna,
!>
!>SELECT model_number, min(model_number)
!>FROM model_table
!>group by model_number
!>order by model_number
!>/
!>
!>
!>--
!>Charles_Dye_at_corp.dialog.com
!>
!>

Why the 'order by', Charles? The 'group by' does the necessary ordering, doesn't it?

-- 
Kind reGards
     \ /   |
      X    |
     / \   s
     Gerard

Received on Sat Mar 23 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Thomas J Kyte: "Re: ORA-01562: ...failed to extend rollback segment.. when update/delete stmt issued..."
Previous message: Hadar Paiss: "Re: HELP: Can't Install Personal ORacle7"
Maybe in reply to: Donna Kray: "Need SQL guru's help: Best query?"
In reply to Charles Dye: "Re: Need SQL guru's help: Best query?"
Next in thread: Thomas J Kyte: "Re: ORA-01562: ...failed to extend rollback segment.. when update/delete stmt issued..."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message