SQL语句中选择记录时如何去掉重复，谢谢！

[happybeyond]

就告诉我这条语句如何写就好，我忘了，谢谢！

[xchonglfm]

SELECT DISTINCT au_id
FROM titleauthor

[maltose]

select distinct XXX，XXX from XXX
where XXX;

[东方小女人]

select distinct field from table where ...

[maltose]

csdn好有意思哦，
我们同时发的贴，
被人抢先了，呵呵

[zxm954712]

Please be careful to use distinct. Because extra memory will be allocated for sorting the record (If memory is not enough to do this job, hard disk will perform it), so it will slow down the sql execution.