query disaster

[fahad siddiqui]

i have a table with

 tyche_id and summit_id, 

these are not unique.
so, i have multiple rows of

 tyche_id with the same summit_id 

such as shown below:

tyche_id     summit_id
12344         C1234
12345         c1235
12344         C1234
12345         c1235
 

I hope you got the idea of the data in the table.
I want to fetch all the rows from this table with unique

tyche_id.

so the fetch should display data something like this

tyche_id      summit_id
12344         C1234
12345         c1235

Can you give me a query for this kind of result fetching?
thanks in advance

[Jan Cumps]

Two possible solutions:

select [B]distinct [/B]tyche_id , summit_id from your_table;

or

select tyche_id , summit_id from your_table [B]group by tyche_id , summit_id[/B]

Regards, Jan

[fahad siddiqui]

i little mistake in my analysis:

tyche_id      summit_id
12344          C1234
12344           0
12345           C1235
12345           0
12346           C1223
12346           C1223
12347           0
12347           0

i want to select unique

 tyche_id's

with a good value of

 summit_id. 

good value means, C123.. kind of string in case values are 0 and C123..
0 in case all the values are 0.
Other than zero, the other string value will always be same.

[Paul Campbell]

what Jan said with a where clause of summit_id = 'c123'

[fahad siddiqui]

the ids were an example. I need to fetch all the rows in a similar fashion.

[Emanuel Kadziela]

You might be able to get what you want this way:

select tyche_id,max(summit_id) from "your table" group by tyche_id.

the group by will get you uniqueness of the tyche_ids and the aggregate function will get you some meaningful value for the summit_id, unless it's 0 in which case it will return the 0. It's a bit of a kludge, but it might work. Otherwise, you will have to use a combination of join, group by and case statements to craft the result set more precisely to your needs.

[fahad siddiqui]

will

 max(summit_id) 

work? the type of the column is varchar and the data is also varchar.

the case statement does work. thanks.

[Jan Cumps]

You will get the alphabetic maximum, not the numerical one.