Distinct records problem

[psamy]

Hi , I want to read the distinct records with multiple columns. for example, tableA -------- OID CODE 1 READ 2 READ 3 WRITE 4 WRITE select distinct CODE, OID from tableA it gives, READ 1 READ 2 WRITE 3 WRITE 4 but expected result was, READ 1 WRITE 3

[seea]

man this sql script is not work like this .... u should use the group by function to get that effect and any aggr functions select CODE, min(OID) from tableA group by CODE This should fetch you the result

thanks, SeEa

[ra ra ra ra]

hmm not sure exactly what your looking for so I'm going to assume you want: the lowest OID for each distinct CODE which is: select CODE, MIN(OID) from tableA group by CODE which would give your desired result. DISTINCT is no way appropriate for what your trying to do in this case!

[psamy]

don't assume you have OID in number format OID CODE x READ y READ z WRITE .. this scenorio expected result will be, OID CODE x READ z WRITE

[ra ra ra ra]

if you didn't want us to assume , then you should have stated clearly in your orig post, instead of wasting our time................. dunderhead

[seea]

In that case also teh above approach of grouping by should work !!!

thanks, SeEa