Achieve a daily ranking version

imoo00

Need to achieve the top 100 ranking version of all songs yesterday,
Song list and Song list first

How to get the traffic of each song yesterday?

With traffic, you can rank

Everyone just teach me how to get the traffic of each song yesterday

anxious! !!

世风日下

select top 100 * from biao where your date field = yesterday (DateDiff('d',sysdate, your date field) order by desc

世风日下

Dizzy, wrong


select top 100 * from biao where DateDiff('d',sysdate,yourdate)=1 order by ranking version desc

--Please pay attention to these two dates. I forgot which one came first and which came later.
DateDiff('d',sysdate,yourdate)=1