试试Select * from NEW A
Where n_nb=1
And Exists(Select * from NEW Where n_nb=1 And n_date>A.n_date Having Count(*) =1)
Where n_nb=1
And Exists(Select * from NEW Where n_nb=1 And n_date>A.n_date Having Count(*) =1)
(select top 2 * from new where n_nb = 1 and N_data = (select max(N_data) from new)
order by n_id desc) a
(select top 2 * from new where n_nb = 1 order by n_date desc) a
order by a.n_date desc
n_date是表NEW的字段,n_nb,n_nl也是表NEW的字段。n_nl是存放内容的。n_nb存放0和1。
现在我想显示n_nb为1的,日期为最新的第二条的内容.(即就是最近的日期排第二那条.)第一種方法用子查詢select top 1 * from
(
select top 2 * from NEW
where n_nb=1
order by n_date desc
) B
order by n_date desc
第二種方法用臨時表
select identity(int,1,1) ID * into #temp from NEW
where n_nb=1
order by n_date desc
select * from where ID=2
想是第幾條就是ID就等於幾