sql server odbc: SQL Query and Distinct -- sql server odbc

SQL Query and Distinct

Nicolas
3/22/2006 5:56:06 PM

sql server odbc:

What should be the SQL Query syntax to get the result:
Basicaly it's a dinstinct on "Name" but the DocUNID is always quicking in

Query not working: SELECT DISTINCT sysEnum.Name, sysEnum.docUNID FROM
sysEnum ORDER BY sysEnum.Name ASC;

Desired Results:
{F77A1DCD-3948-4761-B38F-C5DD0A823196} ListType
{CC626E01-A3AE-444B-BB89-075DEF192725} Module
{7928EE15-C6B2-4F53-B9C9-7B8BED227574} UserType

Here is the table "sysEnum"
DOCUNID
Name

{F77A1DCD-3948-4761-B38F-C5DD0A823196} ListType
{E0F887EA-7573-4D00-9DE2-43D68435F9CB} ListType
{BB83F135-608E-4104-A5A4-2E1D26AEE6DA} ListType
{CC626E01-A3AE-444B-BB89-075DEF192725} Module
{3C6A6B47-1DCE-42CB-8859-66D6BAB479B5} Module
{CF7678C2-39BE-4A7A-9695-48445C99C8FF} Module
{7928EE15-C6B2-4F53-B9C9-7B8BED227574} UserType
{0E3AA5C8-953F-4146-A7EB-92164100C67A} UserType
{942CCCB1-CBCB-4B47-8BA6-EF34CEA1DA03} UserType
{5CA375D8-87ED-4FE3-83B9-4098CC3AB73E} UserType

Thanks for the help
Nicolas

Re: SQL Query and Distinct

Sue Hoegemeier
3/22/2006 9:37:57 PM

If you are only returning one row for each Name, what
criteria do you need for that one row and the DocUNID
returned for that one row? If you don't care, you can use
something like:
SELECT Max(sysEnum.DocUNID), SysEnum.Name
FROM sysEnum
GROUP BY SysEnum.Name

-Sue

On Wed, 22 Mar 2006 17:56:06 -0500, "Nicolas"
[quoted text, click to view]

Re: SQL Query and Distinct

Nicolas
3/23/2006 12:00:00 AM

Thank you Sue for the help. It works with little modification as DocUNID is
uniqueidentifier

SELECT Max(CAST(sysEnum.DocUNID AS VARCHAR(50))) AS DocUNID, SysEnum.Name
FROM sysEnum
GROUP BY SysEnum.Name

Again thank you
Nicolas

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server odbc group.