question

varun 1 avatar image
varun 1 asked

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
sqlsql-server-2008-r2
1 comment
10 |1200

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

KenJ avatar image KenJ commented ·
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 Like 1 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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