On Thu July 24 2003 23:13, Daniel Destro do Carmo wrote: > Hello All, > > I a program in Java to read the logs recorded in MySQL DB and > then make the billing for each customer's calls. > > I have faced a big problem that is: When I list the records > from the table radacct or even if I use two table (one for > start and another for stop) I find a lot of duplicated > registers which makes my Billing incorrectly. > > How can I select (using SQL) just the unique records to see > how many calls and to calculate the total time each user has > used??? > > Thanks for your time > Daniel
Postgres has a UNIQUE keyword, not sure about MySQL.. -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
