SQL排序的问题。。。

[ppsniffer]

SELECT TOP 10 * FROM [book] where bookid in (1065003,1067113,1039748,1067630,1066993,1061085,1060138,1058105,1063632,1056890,1064456,1066585,1062870,1055856) 

查询结果怎样根据()括号里面的顺序排序？

比如ID为1065003排第一，1067113第二这样。。

[donglin0316]

都不清楚你是要升序还是降序呢

[misswangjinfeng]

[Quote=引用 3 楼 lindping 的回复:]
数据库不可能能按照你的输入参数去排列数据，也没有必要这么做，你把数据取出来以后在内存里做个排序就行了，比如 把参数放入List <int>,取其索引作为排序
list<int> list = new list<int>{ 1065003,1067113,...}
books = books.orderby(p=> list.IndexOf(p.booid));
[/Quote]

LZ用这个吧

[donglin0316]

搞明白了 你是想根据你自己排的编号查信息吧

[rekym]

LZ是想要根据参数的输入顺序，查询出来的数据也是按个顺序的。。。

用3#的~~~~~~~~~

[PitTroll]

SELECT TOP 10 * FROM [book] where bookid in (1065003,1067113,1039748,1067630,1066993,1061085,1060138,1058105,1063632,1056890,1064456,1066585,1062870,1055856) order by bookid asc

[michaelgong]

SELECT TOP 10 * FROM [book] where bookid in (1065003,1067113,1039748,1067630,1066993,1061085,1060138,1058105,1063632,1056890,1064456,1066585,1062870,1055856) order by asc

asc 升序 (默认)
desc 降序

[lindping]

数据库不可能能按照你的输入参数去排列数据，也没有必要这么做，你把数据取出来以后在内存里做个排序就行了，比如 把参数放入List <int>,取其索引作为排序
list<int> list = new list<int>{ 1065003,1067113,...}
books = books.orderby(p=> list.IndexOf(p.booid));

[duan_dream]

[Quote=引用 2 楼 michaelgong 的回复:]
SQL code

SELECT TOP 10 * FROM [book] where bookid in (1065003,1067113,1039748,1067630,1066993,1061085,1060138,1058105,1063632,1056890,1064456,1066585,1062870,1055856) order by asc


asc 升序 (默认)
……
[/Quote]
顶。。。。

[子夜__]

[Quote=引用楼主 ppsniffer 的回复:]
SQL code

SELECT TOP 10 * FROM [book] where bookid in (1065003,1067113,1039748,1067630,1066993,1061085,1060138,1058105,1063632,1056890,1064456,1066585,1062870,1055856)



查询结果怎样根据()括号里面的顺序排序？

比……
[/Quote]
你是要先排序还是后排序。。

create table #b
(CC nvarchar(50))

select * from #b

insert into #b select '1065003'
union select '1065003'
union select '1067113'
union select '1039748'
union select '1067630'
union select '1066993'
union select '1061085'
union select '1060138'
union select '1058105'
union select '1063632'
union select '1056890'
union select '1064456'
union select '1066585'
union select '1062870'
union select '1055856'


--先查找后排序
SELECT TOP 10 * FROM [book] where bookid in (select * from #b) order by asc

--先排序后查找
SELECT  * FROM [book] where bookid in (select TOP 10 * from #b order by asc) 

[ppsniffer]

问题已经解决

SELECT TOP 10 * FROM [book] where bookid in (1065003,1067113,1039748,1067630,1066993,1061085,1060138,1058105,1063632,1056890,1064456,1066585,1062870,1055856) 
order by charindex(','+cast(bookid as varchar)+',',',1065003,1067113,1039748,1067630,1066993,1061085,1060138,1058105,1063632,1056890,1064456,1066585,1062870,1055856,')