如何在SQL中选择收藏的行 [英] how do select favorite Row in sql

问题描述

大家好

在我的程序中，我需要在2个日期之间变得不同...

我正确选择了下面的第二行:

hi all

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

I Select The 2 Top Row Correctly With Follow :

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

使用Abow代码，我可以获得以下信息:

With Abow Code I Get These Information :

2012/04/22
2012/04/26

现在...我需要将这些信息分为2部分，以计算它们之间的差异...

我该怎么办?

在其他说明中，我要:

1-发送2个参数 [pay_sm_id] 和 [pay_cus_id]
2-获取2个日期字段之间的区别([pay_date])(仅具有Select和DATEDIFF函数)

请帮助我...

一大堆钱

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

推荐答案

试试这个:

Hi,
Try this:

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

上面的查询将返回DD的Diff，为了获取YY和MM，您需要更改DD，因为DATEDIFF需要3个参数.

希望对您有帮助，
干杯

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

您需要这个:
=

you need this:
=

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)

尝试以下解决方案:

Hi,

Try this solution:

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)
)

这篇关于如何在SQL中选择收藏的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！