July 23rd, 2010, 02:55 AM
Join Date: Jul 2010
Time spent in forums: 52 m 19 sec
Reputation Power: 0
How to Find Out Distinct Records?
I want to find out distinct records in my query. Following is the query
SELECT DISTINCT m.client_id,t.Acc_NUM
FROM MST_MASTER m,
GROUP BY m.client_id,t.Acc_NUM
The Out put i m getting is :
I want distinct records for client_id.
Any hep is appreciated.