dealing large database of firm - database houses record of payments , firm suppliers. want find out whether duplicate/ triplicate payments have been made suppliers on period of time. way can interact database using plugin via excel , sql coding. suggestions on how may go doing this?
completion of task isn't urgent. want start somewhere , develop question on time.
select suppliername,date, count(*) nb yourtable date >= 'put date' group suppliername,date having ( count(*) > 1 ) 
Comments
Post a Comment