how do select favorite Row in sql

Question

2.50/5 (2 votes)

See more:

hi all

In My Program i Need To get Different between 2 Date ...

I Select The 2 Top Row Correctly With Follow :

SQL

select TOP 2 [pay_date] from  [Peyment] where [pay_sm_id]=2 and [pay_cus_id]=3

With Abow Code I Get These Information :

2012/04/22
2012/04/26

NOW ... i need seperate these Information to 2 part To Calculate Different Between it ...

How Do I ?

In Other Description I Want :

1- Send 2 parameters [pay_sm_id] and [pay_cus_id]
2- Get Diferent Between 2 Date Field ([pay_date]) (Only With Select And DATEDIFF Function)

Please Help Me ...

TNK A LOT

Posted 18-Apr-12 5:19am

Esmaeil Ebrahimi

Add a Solution

3 solutions

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)

Reza Ahmadi · Answer 1 · 2012-04-18T05:34:00

Solution 1

Hi,
Try this:

SQL

select DATEDIFF(DD,[pay_date],(select [pay_date] from  [Peyment] where [pay_cus_id]=3)) as datediff1 from  [Peyment] where [pay_sm_id]=2

The above query will return Diff of DD, in order to get YY and MM, you need to change DD as DATEDIFF requires 3 parameters.

I hope it helps,
Cheers

Posted 18-Apr-12 5:34am

Reza Ahmadi

Updated 22-Apr-12 20:41pm

v3

Comments

[no name] 18-Apr-12 11:44am

Thanks Reza Ahmadi ... But Not Work
Is It Correct That :
Select Top 1 From Top 2
Then
Select Last Record From Top 2
?
If It Is Correct Please take out That For Me Please...

milenalukic · Answer 2 · 2012-04-22T15:00:00

Solution 2

you need this:
=

SQL

Declare @paydate1 datetime
Declare @paydate2 datetime
Select @paydate1 = TOP 2 [pay_date] from  [Peyment] where [pay_sm_id]=2 and [pay_cus_id]=3
Select @paydate2 = TOP 2 [pay_date] from  [Peyment] where [pay_sm_id]=2 and [pay_cus_id]=3 order by [pay_date] desc

select datediff(dd,@paydate1,@paydate2)

Posted 22-Apr-12 15:00pm

milenalukic

Comments

[no name] 23-Apr-12 1:00am

ORDER BY DESC sometimes create problem is an indexes based on this column with desc.
Check my solution.

MaulikDusara · Answer 3 · 2012-04-22T18:58:00

Hi,

Try this solution:

SQL

SELECT DATEDIFF(DAY,
    (SELECT STATUS_DATE FROM(SELECT TOP 2 ROW_NUMBER()OVER(ORDER BY ORGANIZATION_ID DESC)AS [ROWID],[PAY_DATE] FROM  [PEYMENT] WHERE [PAY_SM_ID]=2 AND [PAY_CUS_ID]=3)AS TBL WHERE ROWID = 1),
    (SELECT STATUS_DATE FROM(SELECT TOP 2 ROW_NUMBER()OVER(ORDER BY ORGANIZATION_ID DESC)AS [ROWID],[PAY_DATE] FROM  [PEYMENT] WHERE [PAY_SM_ID]=2 AND [PAY_CUS_ID]=3)AS TBL WHERE ROWID = 2)
)