SQL语句，取数据库中前五条数据，并且把5条数据转成行的形式显示出来


SQL语句怎么写啊？

[解决办法]
如果是说要把它们显示在一行中,则:

SQL code

select createdate,sum(case when rn=1 then torquevalue else 0 end) as [1],sum(case when rn=2 then torquevalue else 0 end) as [2],sum(case when rn=3 then torquevalue else 0 end) as [3],sum(case when rn=4 then torquevalue else 0 end) as [4],sum(case when rn=5 then torquevalue else 0 end) as [5]from(select torquevalue,createdate,rn from(select row_number()over(partition by createdate order by (select 1))rn from tb)t where rn<=5)t1 group by createdate
[解决办法]
SQL code
;with f as(select id=row_number()over(order by getdate()),* from tb)select   distinct b *from   f across apply   (select top 5 * from f where create=a.create order by id)b
[解决办法]
SQL code
create table buqingle(x int, y date)insert into buqingle select 151,'2011-09-15' union allselect 152,'2011-09-15' union allselect 153,'2011-09-15' union allselect 154,'2011-09-15' union allselect 155,'2011-09-15' union allselect 156,'2011-09-15' union allselect 157,'2011-09-15' union allselect 181,'2011-09-18' union allselect 182,'2011-09-18' union allselect 183,'2011-09-18' union allselect 184,'2011-09-18' union allselect 185,'2011-09-18' union allselect 201,'2011-09-20' union allselect 202,'2011-09-20' union allselect 203,'2011-09-20' union allselect 204,'2011-09-20' union allselect 205,'2011-09-20'with t2 as(select y,x,rnfrom(select row_number() over(partition by y order by getdate()) rn,x,y from buqingle) twhere t.rn<=5)select y '日期',[1] '第一个值',[2] '第二个值',[3] '第三个值',[4] '第四个值',[5] '第五个值'from t2pivot(sum(x) for rn IN ([1],[2],[3],[4],[5])) t3  日期       第一个值      第二个值     第三个值     第四个值      第五个值---------- ----------- ----------- ----------- ----------- -----------2011-09-15   151         152         153         154         1552011-09-18   181         182         183         184         1852011-09-20   201         202         203         204         205(3 row(s) affected)