Loading

give sql query syntax

pinkal patel

16y3kSQL

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Crish16y ago
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'
Sreekanth16y ago
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'