Forums

This topic is locked

Becoming DISTINCT

Posted 30 Jul 2002 17:40:20
1
has voted
30 Jul 2002 17:40:20 Simon Bloodworth posted:
I feel quite stupid, but for the life of cant remember the sql for returning distinct results from one coloumn in a database.

Can someone bring out of this fazed stuper that i'm in please?

Red Leader

Replies

Replied 30 Jul 2002 21:22:07
30 Jul 2002 21:22:07 Owen Eastwick replied:
SELECT DISTINCT FieldName FROM TableName

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
Replied 01 Aug 2002 12:30:11
01 Aug 2002 12:30:11 Simon Bloodworth replied:
Cheers very much.

Red Leader
Replied 05 Aug 2002 23:17:47
05 Aug 2002 23:17:47 chris espino replied:
I got this book 'SQL Qeuries for Mere Mortals' ...

literally explains to you each SQL commands to use, very very helpful.

Reply to this topic