3 Replies Latest reply: Feb 17, 2012 6:43 AM by Celambarasan Adhimulam RSS

Need to find out duplicate values in a table/chart.

Shubham Kumar

Hi,

 

I have some table where we consider the three differen fields value which is in text and date. If I want to put a condition between all three like if all three fields are same for same passeger that means that ticket is duplicate. And I want to know the ticket number based on all three fields value only if the fields are matching twice or more than that. Could any one please let me know the solution.

EX;_

 

( route & Passenger & Dateof departure) > 1, that means all the three values are if matching for the same passenger and date of journey and itinary is same that means it should show the duplicate ticket number.

 

Please help.

 

Best,

Shubham