give sql query syntax

Question

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

Crish · Answer

use below sql query.. select Date  clientname  deposit_amount from Table_Name where deposit_amount=500 select Date  clientname  deposit_amount from Table_Name where DATE >= '17/16/2010'

Sreekanth · Answer

select Date  clientname  deposit_amount from Table_Name where deposit_amount=500 !!! or u can check by date select Date  clientname  deposit_amount from Table_Name where DATE= '17/16/2010'