SQL Distinct

  • Thread starter Thread starter Nicolas
  • Start date Start date
N

Nicolas

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
 
Nicolas said:
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
Click to expand...


Actually this is a SQL question, not a VB.Net question, but...


Why is it

{F77A1DCD-3948-4761-B38F-C5DD0A823196} ListType

not

{E0F887EA-7573-4D00-9DE2-43D68435F9CB} ListType

?


Armin
 
This is an enumrator table so I got one table for the enumator per say and
another table with the enumerator name that is is to be use with custom
globalization for title


This should list the type of enumerator
DocUNID
Name DefaultValue en
fr es
{F77A1DCD-3948-4761-B38F-C5DD0A823196} ListType
"ListType" Type of List Type de liste
{CC626E01-A3AE-444B-BB89-075DEF192725} Module
"ModuleList" List of Module Liste de modules


This is the global Table for all enumerator
Then I got the other table for those enum
DocUNID
Name ID DefaultValue en
fr es
{F77A1DCD-3948-4761-B38F-C5DD0A823196} ListType 0
Item1
{E0F887EA-7573-4D00-9DE2-43D68435F9CB} ListType 1
Item2
{BB83F135-608E-4104-A5A4-2E1D26AEE6DA} ListType 2
Item2
{CC626E01-A3AE-444B-BB89-075DEF192725} Module 0
Module1
{3C6A6B47-1DCE-42CB-8859-66D6BAB479B5} Module 1
Module2
{CF7678C2-39BE-4A7A-9695-48445C99C8FF} Module 2
Module3
 
Nicolas said:
This is an enumrator table so I got one table for the enumator per say and
another table with the enumerator name that is is to be use with custom
globalization for title


This should list the type of enumerator
DocUNID
Name DefaultValue en
fr es
{F77A1DCD-3948-4761-B38F-C5DD0A823196} ListType
"ListType" Type of List Type de liste
{CC626E01-A3AE-444B-BB89-075DEF192725} Module
"ModuleList" List of Module Liste de modules


This is the global Table for all enumerator
Then I got the other table for those enum
DocUNID
Name ID DefaultValue en
fr es
{F77A1DCD-3948-4761-B38F-C5DD0A823196} ListType 0
Item1
{E0F887EA-7573-4D00-9DE2-43D68435F9CB} ListType 1
Item2
{BB83F135-608E-4104-A5A4-2E1D26AEE6DA} ListType 2
Item2
{CC626E01-A3AE-444B-BB89-075DEF192725} Module 0
Module1
{3C6A6B47-1DCE-42CB-8859-66D6BAB479B5} Module 1
Module2
{CF7678C2-39BE-4A7A-9695-48445C99C8FF} Module 2
Module3
Click to expand...


Sorry, but it's hard for me to recreate the columns from this posting. Also
always use a fixed-width font in newsgroups. What ist the column DocUNID and
what is Name?


Armin
 
Thanks for try to help, I got the answer from another news group as you
mention SQL newsgroup
Here is the answer:

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

Nicolas
 
Back
Top