Click here to Skip to main content
14,431,211 members

sql queries problem

nilong asked:

Open original thread
sql queries problem

--------------------
i have one tabel with column name
date,client_name,deposit_amount

----------------table overview----------
date | client_name | deposit_amount
-------- ------------ -------------
17/06/2010 abc 1500
18/06/2010 abc 500
19/06/2010 abc 0.00
17/06/2010 xyz 1000
18/06/2010 xyz 500
16/06/2010 mnp 2000
19/06/2010 mnp 500
---------------------------------------
how to fetch client_name with max date and deposit_amount>0

if true then fine a record like this.....

----------------table overview----------
date | client_name | deposit_amount
-------- ------------ -------------

18/06/2010 xyz 500
19/06/2010 mnp 500
--------------------------------------

how to find this type of result with use of sql queries..
Tags: C#, SQL, ASP.NET, Server

Preview



When answering a question please:
  1. Read the question carefully.
  2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
  3. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
  4. Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.
Let's work to help developers, not make them feel stupid.
Please note that all posts will be submitted under the The Code Project Open License (CPOL).




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100