i have problem using distinct query. I have table it has 22 fields. call_id is repeted
because of maintain the history. when i insert the same record as another record some
filelds should change the datas like closed_date, engineer_name, solution_descri ption.
the another contacts details never changed. i am select the distinct call_id and i want
to retive the all fields. but it throughs duplicat values so give me solution it is very
urgent.
Note : distinct query throughs duplicat valuse
because of maintain the history. when i insert the same record as another record some
filelds should change the datas like closed_date, engineer_name, solution_descri ption.
the another contacts details never changed. i am select the distinct call_id and i want
to retive the all fields. but it throughs duplicat values so give me solution it is very
urgent.
Note : distinct query throughs duplicat valuse
Comment