Submit My Question - Recent Questions - Recent Answer
Msdn China Tech >> MS-SQL Server >> 疑难问题

排序

select a.customerID ,count(a.customerID) from customers a, customers b where a.customerID >=b.customerID group by a.customerID
[129 byte] By [sky_blue-蓝天2007] at [2008-5-24]
«« 我的树形结构保存汉字(treeviewitem.label)的时候,写入数据库的是 ?的符号,怎么办
»» 今年高程上午考试内容好象有很多内容超出2002考试大纲范围,我们买考试大纲干什么?
# 1
有什么问题？

如果要求列出customers的内容，加多一个名次项呢？
CSDNM-决定不当CSDN经理了 at 2007-10-24 > top of Msdn China Tech,MS-SQL Server,疑难问题...
# 2
加 order by a.customerID
CSDNM-决定不当CSDN经理了 at 2007-10-24 > top of Msdn China Tech,MS-SQL Server,疑难问题...
# 3
不太清楚你问题的意思，是不是把：
group by a.customerID
改成
order by a.customerID
mo_hui-mo_hui at 2007-10-24 > top of Msdn China Tech,MS-SQL Server,疑难问题...
# 4
select a.customerID ,count(a.customerID) Idd from customers a, customers b where a.customerID >=b.customerID group by a.customerID
order by Idd
tj_dns-愉快的登山者 at 2007-10-24 > top of Msdn China Tech,MS-SQL Server,疑难问题...
MS-SQL Server
疑难问题

MS-SQL Server Hot Topic

MS-SQL Server New Topic

MS-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