Find the data after the filtering time?

jjyytmlb

As table (TalbeA):
id title addtime
1 abc 2016-2-3
.
.
.
Need to take seven pieces of data:
Take seven data from addtime today. If it is insufficient, take yesterday's data. Otherwise, take the past 2 days, and so on, and make sure to make up seven data.
Thank you!

fanfan1980

--try

select top 7 * from TalbeA
where addtime <= getdate ()
order by addtime desc

jjyytmlb

＠fanfan1980
Thanks

Ugh! I'm so dizzy (I'm too stupid)

我是杀人狂

select * from TalbeA
where addtime in (select top 7 addtime from TalbeA order by addtime desc)

wgfxman

select top 7 * from TalbeA
where addtime <convert (char (10), getdate () + 1,102)
order by addtime desc

jjyytmlb

It ’s too simple, I ’m all dizzy. I ’m obviously ranked today. . . I am dizzy.