请问查询语句不出现重复记录的命令是什么，急等

[tangchengze]

请问查询语句不出现重复记录的命令是什么，急等

[dfwxj]

不是group,
只要加上dist 子句即可

[tangchengze]

sele dist * from e:/b1,e:/b2

为什么不对

[fj_jiangqi]

sele dist(不重复的字段) * from e:/b1,e:/b2
-------------------------
我流落在凄凉的世界里－孤苦伶仃
我过着动荡无助的生活－四处漂泊

[noproblem12]

group by

or

select DISTINCT * from .........

[qufusongyu]

DISTINCT
在查询结果中剔除重复的行。每一个 SELECT 子句只能使用一次 DISTINCT。
SELECT [ALL | DISTINCT] [TOP nExpr [PERCENT]] [Alias.] Select_Item
[[AS] Column_Name] [, [Alias.] Select_Item [[AS] Column_Name] ...]
FROM [FORCE] [DatabaseName!] Table [[AS] Local_Alias]
[ [INNER | LEFT [OUTER] | RIGHT [OUTER] | FULL [OUTER] JOIN DatabaseName!]
Table [[AS] Local_Alias] [ON JoinCondition ...]
[[INTO Destination] | [TO FILE FileName [ADDITIVE] | TO PRINTER [PROMPT] | TO SCREEN]]
[PREFERENCE PreferenceName] [NOCONSOLE] [PLAIN] [NOWAIT]
[WHERE JoinCondition [AND JoinCondition ...] [AND | OR FilterCondition [AND | OR FilterCondition ...]]]
[Group By GroupColumn [, GroupColumn ...]] [HAVING FilterCondition] [UNION [ALL] SELECTCommand]
[Order By Order_Item [ASC | DESC] [, Order_Item [ASC | DESC] ...]]

[noproblem12]

sele dist * from e:/b1,e:/b2

e:/b1,e:/b2 是什么？是表名？写的格式错误

[magnetmoon]

sele dist * from e:\b1,e:\b2

[wick]

sele dist * from e:/b1,e:/b2
为什么不对

首先我认为表中不太会出现重复记录
所以，
你先查一下表的记录是不是有重复，如果没有，那存不存在dist的结果是一样的，
如果有重复记录，那取重复记录的一条。
最后
dist一般用于从表中选取一些字段的组合