467,134 Members | 930 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,134 developers. It's quick & easy.

select distinct * --- possible??

Hello everyone,

i have a table with 300 columns (imported from a text file). Is it possible to write a "select distinct * from tablename" statement. it would be tedious to write 300 column names for DISTINCT...so will DISTINCT * work here??? if not what else could be the best way to select distinct records? Thanks.
Nov 17 '08 #1
  • viewed: 1260
3 Replies
Expert 2GB
Did you try it?

-- CK
Nov 17 '08 #2
Yes i did try . The entire table is displayed with all records & duplicate values in columns.not the desired result i want.
Nov 17 '08 #3
Expert 2GB
Could you post the result here? Just a few columns and rows that shows those duplicates.

-- CK
Nov 17 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Bob Bedford | last post: by
14 posts views Thread by Craig Hoskin | last post: by
3 posts views Thread by Tcs | last post: by
5 posts views Thread by Daniel Wetzler | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.