Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> Transact-SQL

Rollup

Hi,

I have a table in a particular order which I ned to maintain.when I say select a,b, from tab group by a,b,c with rollup the order of the output is changed.How can I avoid this.

thanks,
ssm

[201 byte] By [SSM] at [2008-2-6]
«« Licensing question
»» Problems with authentication
# 1
GROUPING and ROLLUP may not preserve order. You will need to add an ORDER BY clause to your query.
CliffordDibble at 2007-9-9 > top of Msdn Tech,SQL Server,Transact-SQL...
SQL Server
Transact-SQL

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified