CodingForums.com - View Single Post

Gozirra · 06-27-2002, 04:43 AM

Just so you know, distinct selects distinct rows, not a distinct column. Thus, select distinct col1, col2 from x will give you all distinct rows. If col1 = x 100 times but col2 = x+1 within each row, you will get 100 rows in your result set.

Peace, Love, and Darth Vader.

06-27-2002, 04:43 AM	PM User \| #4
Gozirra New to the CF scene Join Date: Jun 2002 Location: Illinois Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts	Let me splain Just so you know, distinct selects distinct rows, not a distinct column. Thus, select distinct col1, col2 from x will give you all distinct rows. If col1 = x 100 times but col2 = x+1 within each row, you will get 100 rows in your result set. Peace, Love, and Darth Vader.