摘要:
141. View the Exhibit and examine the structure of CUSTOMERS and GRADES tables.You need to display names and grades of customers who have the highest ... 阅读全文
摘要:
row_number()over( partition by a order by b desc ) rn根据【字段a】分组,分组内根据【字段b】排序,次函数返回的是每组内部排序后的序列号(分组内唯一不重复排序)例子:一张表,求按date,pay排序后的数据,且每天数据只有3条select date... 阅读全文