RSS

is order by and group by the same?

Please support our MySQL advertiser: Programming Forums

is order by and group by the same?

•

Join Date: Jul 2005

Posts: 41

Reputation: ohgosh is an unknown quantity at this point

Rep Power: 4

Solved Threads: 0

ohgosh

Offline

Light Poster

is order by and group by the same?

Sep 15th, 2005

Hi there,

wanna ask if the sql syntax order by and group by the same?
eg: i have a dropdownlist and the values displayed should be in ascending order. hence is there any difference if i use these 2 sql statements below.

Help with Code Tags

(Toggle Plain Text)

sql1 = "select distinct * from t_staff group by staff"
sql2 = "select distinct * from t_staff order by staff"

i've tested it out and it works well. was curious to know if there is any explaination/meaning behind the scene.

Though i know it may be peanut to you guys..but Thanks Alot!

cheers,
ohgosh

DaniWeb Home > Forums > Web Development > Databases > MySQL > is order by and group by...

is order by and group by the same?

is order by and group by the same?

is order by and group by the same?