In Sql How to find 2nd Transaction Date

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

CSS

2110060101092684    1500    2009    23/06/2010 12:00:00 AM  Tr from Rebate  96.0000 NULL    1   1   Pacs    Direct  NULL    17768   Transfer    147059  NULL    1092    96.0000 NULL    NULL    NULL    NULL    00031
2110060101092684    1500    2009    21/08/2010 12:00:00 AM  Transfer    NULL    450.0000    2   3   Pacs    Direct  20/08/2011 12:00:00 AM  17911   Transfer    99  NULL    1092    NULL    NULL    NULL    NULL    NULL    00031
2110060101092684    1500    2009    26/03/2011 12:00:00 AM  Cash    21914.0000  NULL    2   3   Pacs    Direct  NULL    19055   Cash    521849  125.0000    1092    20354.0000  1426.0000   9.0000  0.0000  NULL    00031
2110060101092684    1500    2009    30/03/2011 12:00:00 AM  Transfer    NULL    35000.0000  2   3   Pacs    Direct  29/03/2012 12:00:00 AM  19263   Transfer    64  NULL    1092    NULL    NULL    NULL    NULL    NULL    00031

I need to after withdrawal amount TransactionDate Transactions
How to write the query

Posted 6-Sep-11 1:58am

JKChowdary

Updated 6-Sep-11 2:11am

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
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.
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.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2011-09-06T02:13:00

One way to do this is something like (if transactiondate defines uniquely the order):

SQL

select *
from tablename tn
where 1 = (select count(*)
           from tablename tn2
           where tn2.transactionadate < tn.transactiondate)

That should select the row having the second lowest transaction date.