Comparing values of a column in a group
560315Apr 4 2007 — edited Apr 4 2007Hi All,
i have key, dt, col1
1, dt1, a
1, dt2, b
2, dt1, a
2, dt2, a
2, dt3, a
i need to check whether all values of col1, for column key is same or different.
in the example key 1 has difft values for col1,
key 2 has same values for col1.
how can i achieve this in a single sql query?
thanks in advance