Thread
:
GROUP BY vs DISTINCT
View Single Post
#
17
June 1st, 2007, 07:47 PM posted to microsoft.public.access.queries
Michel Walsh[_2_]
external usenet poster
Posts: 56
GROUP BY vs DISTINCT
"Warrio", c'est un alias pour "3stone" ?
Je renvoie le grand bonjour à Pierre, en tout cas.
Vanderghast, Access MVP
"Warrio" wrote in message
...
"3stone" a écrit dans le message de news:
...
|
| Vanderghast, Access MVP
|
Un grand bonjour amical à Michel !
(dommage qu'il ne vient plus sur ce forum...)
--
A+
Pierre (3stone) Access MVP
Perso:
http://www.3stone.be/
MPFA:
http://www.mpfa.info/
(infos générales)
"Michel Walsh" a écrit dans le
message de news: ...
and here is the query plan, again, the same, for both statements (excuse the
HTML format, I suspect that without it, it turns out un-readable):
|--Sort(DISTINCT ORDER BY
[pubs].[dbo].[authors].[au_fname] ASC))
|--Index Scan(OBJECT
[pubs].[dbo].[authors].[aunmind]))
Vanderghast, Access MVP
Michel Walsh[_2_]
View Public Profile
View message headers
Find all posts by Michel Walsh[_2_]
Find all threads started by Michel Walsh[_2_]