sql-排序

--创建视图
CREATE VIEW myview AS
    SELECT * FROM test order by time desc
 --查看视图
SELECT * FROM myview;
--删除视图
DROP VIEW myview

---窗口函数
select id,time,number,row_number() over(order by number asc) as idx from test ;
select id,time,number,rank() over(order by number asc) as idx from test ;
select id,time,number,dense_rank() over(order by number asc) as idx from test ;
--按分组再排名
 select id,time,number,row_number() over(PARTITION by number order by id asc) as idx from test ;
 select id,time,number,cume_dist() over(PARTITION by number order by id asc) as idx from test 

https://www.cnblogs.com/funnyzpc/p/9311281.html

with t1 as (select id as id1,time time1,number number1 from test order by time desc limit 7 offset 0),
t2 as (select id as id2,time time2,number number2 from test order by time desc limit 7 offset 1)
select time1,number1-number2 nu from t1,t2 where t1.time1 = t2.time2+1

时间计算

https://www.cnblogs.com/qiangxia/p/4819469.html