| Author |
 Topic  |
|
|
Informer30
Starting Member
17 Posts |
 Posted - 11/29/2011 : 16:56:00
|
Hi All,
I have a basic select statement and I wanted to know is it possible in sql 2008 to order the group by e.g
select field_a, field_b, field_c, field_d
from table_1
where field_a = 'Student'
Group by field_a (Group1),
field_c (Group2),
field_d (Group3),
field_b(Group4)
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47023 Posts |
Posted - 11/30/2011 : 01:35:25
|
you can
add order by for that
iie,
order by field_a ,
field_c ,
field_d ,
field_b
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
 |
|
|
Informer30
Starting Member
17 Posts |
Posted - 11/30/2011 : 04:00:52
|
| Thanks, that worked... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47023 Posts |
Posted - 11/30/2011 : 10:46:12
|
wc
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
| |
Topic |
|
Grouping order in SQL 2008
