有大佬会这个吗
sql吧
全部回复
仅看楼主
level 2
有大佬会这个吗
2020年03月09日 16点03分 1
level 7

CREATE TABLE customer(ct_id NVARCHAR(50),jj_date DATE ,ct_name NVARCHAR(50),loan_amt MONEY)
GO
INSERT dbo.customer
( ct_id, jj_date, ct_name, loan_amt )
VALUES ( N'kh1', -- ct_id - nvarchar(50)
'2020-03-10', -- jj_date - date
N'客户1', -- ct_name - nvarchar(50)
10000 -- loan_amt - money
)
INSERT dbo.customer
( ct_id, jj_date, ct_name, loan_amt )
VALUES ( N'kh1', -- ct_id - nvarchar(50)
'2020-03-20', -- jj_date - date
N'客户1', -- ct_name - nvarchar(50)
20000 -- loan_amt - money
)
INSERT dbo.customer
( ct_id, jj_date, ct_name, loan_amt )
VALUES ( N'kh2', -- ct_id - nvarchar(50)
'2020-03-10', -- jj_date - date
N'客户2', -- ct_name - nvarchar(50)
20000 -- loan_amt - money
)
INSERT dbo.customer
( ct_id, jj_date, ct_name, loan_amt )
VALUES ( N'kh2', -- ct_id - nvarchar(50)
'2020-03-20', -- jj_date - date
N'客户2', -- ct_name - nvarchar(50)
30000 -- loan_amt - money
)
INSERT dbo.customer
( ct_id, jj_date, ct_name, loan_amt )
VALUES ( N'kh3', -- ct_id - nvarchar(50)
'2020-03-10', -- jj_date - date
N'客户3', -- ct_name - nvarchar(50)
40000 -- loan_amt - money
)
INSERT dbo.customer
( ct_id, jj_date, ct_name, loan_amt )
VALUES ( N'kh3', -- ct_id - nvarchar(50)
'2020-03-20', -- jj_date - date
N'客户3', -- ct_name - nvarchar(50)
5000 -- loan_amt - money
)
INSERT dbo.customer
( ct_id, jj_date, ct_name, loan_amt )
VALUES ( N'kh4', -- ct_id - nvarchar(50)
'2020-03-10', -- jj_date - date
N'客户4', -- ct_name - nvarchar(50)
5000 -- loan_amt - money
)
INSERT dbo.customer
( ct_id, jj_date, ct_name, loan_amt )
VALUES ( N'kh4', -- ct_id - nvarchar(50)
'2020-03-20', -- jj_date - date
N'客户4', -- ct_name - nvarchar(50)
60000 -- loan_amt - money
)
GO
select * from
(select * from
(select ROW_NUMBER()over(partition by ct_id order by jj_date) as num,*
FROM customer
) a
WHERE num=1
) b
WHERE loan_amt>10000
DROP TABLE dbo.customer
2020年03月10日 08点03分 3
1