Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

thread181-27567

Status
Not open for further replies.
Valeriya

Valeriya

MIS
Jan 9, 2006
138
US
Hello! I'me a bit confused about DISTINCT vs DISTINCTROW. I created a query that (pulls all records from one table)with all fields selected...in that case DISINCT & DISTINCTROW should give the same result for the number of records. However, I just found out that the result of one has one more record than the other. How is it possible???

Thanks for your advise,

Valeriya
 
Sort by date Sort by votes
Look for topic "ALL, DISTINCT, DISTINCTROW, TOP Predicates" in the help file.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.
 
Upvote 0 Downvote
DISTINCTROW has the following caveats

[li]Effective only if you are selecting from multiple tables.[/li]

[li]Effective only if you select fields from some, but not all, of the tables in the query.[/li]
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top