Question

这个ASP里的SQL语句怎么写

有一个表有很多字段，其中一个是地址，一个是编号
现在要找到地址不重复的记录并按编号排列，还要得到这些选出记录的全部内容

Answer 1

呵呵，楼上两位的都错了。

如果重复的只是想列出其中一条的话：
select * from table group by adress order by id;

如果只要重复的都不列出的话：

select a.* from table a, table b where a.address = b.address and a.id < b.id order by a.id;

Answer 2

-- 无BUG方式，稍复杂，有简单的但可能会有BUG，所以这是稳定性方面的第一选择。
Select *
From
TableName
Where ID in
(

Select ID From TableName Where Address in
(
Select Distinct Address From TableName
)

)

Order By ID

Answer 3

sql=""
把SQL语句写在""中
然后 conn.open sql 1,2

Answer 4

sql = "select DISTINCT 地址名 * from tablename order by 编号"

Answer 5

设编号字段为ID
Select * From [Table] Where id in (Select Max(id) From [Table] Group by b) order by id desc