Please support our MySQL advertiser: Programming Forums
•
•
Join Date: Jul 2005
Posts: 41
Reputation: 
Rep Power: 4
Solved Threads: 0
Light Poster
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.
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!
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.
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
ohgosh
Similar Threads
Other Threads in the MySQL Forum
- One-way(inbound)links offer (Search Engine Optimization)
- is order by and group by the same? (ASP)
- A new Enterprise Architecture online user group (IT Professionals' Lounge)
Other Threads in the MySQL Forum
- Previous Thread: Updating but bypassign key constraints
- Next Thread: MySQL insert statement
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Threaded Mode