Please help me to write a query to seperate the duplicate (TranDate) rows from the following
Fields :- Job Num, Seq Num, Vendor Last Name, Vendor First Name, Vendor Middle Initial, Agency, TranDate
Data will be as follows,
27809, 1, MILLER , , , Young Men's Association , 12/21/2002
56634, 1, PEOPLES, , , People Inc , 12/02/2003
22345, 2, COX , , , Family Business Corporation, 11/19/2003
22345, 2, COX , , , Family Links , 11/19/2003
Any help would be really appreciated