give sql query syntax

Jun 19 2010 1:34 AM
This Below is my problem:

This value store in database Table :  

  Date     clientname   deposit_amount
17/06/2010  abc            1500
18/06/2010  abc            500
19/06/2010  abc            0.00
17/06/2010  pqr            1000
18/06/2010  pqr            500
16/06/2010  xyz            2000
19/06/2010  xyz            500

I want find below this type of record then which sql query is use

18/06/2010    pqr         500
19/06/2010    xyz         500


pls give solution

Answers (2)