How to get the distinct data from group of Data?

Hi to all I've the Record like SNO 2 3 5 10 29 43 74 1 ---------- PICKUP_STAGE 6 16 80 9 6 5 7 10 ---------- DROP_STAGE 6 16 0 9 0 5 7 10 ---------- PICKUP_TRIP 2 2 2 1 2 2 1 2 ---------- DROP_TRIP 3 3 3 4 3 3 4 3 Here i could not post data in table so that i post like this. Here i've to get the data based on trip distinct. for example pickup\_trip 2 has repeated pickup stage 6. I've to get the only one 6 pickup\_stage with other distinct stage to that particular pickup\_trip Please Help me Thanks to all

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ commented · Oct 12, 2011 at 11:33 PM

Are these separate tables or different columns within the same table? If they are columns, which row with `PICKUP_STAGE` 6 should I throw out? If they are tables, I can guess from you description that the first row in `PICKUP_TRIP` goes with the first row in `PICKUP_STAGE` but I don't know for certain that would be correct, and it certainly can't be acted upon programmatically since data order is not guaranteed.

1 ·

question