rec_id No name
001 Y 101 材料1
002 Y101 材料1
003 Y101 材料1
004 Y102 材料2
005 Y102 材料2
006 Y103 材料3
007 Y104 材料4
我现在想得到一下结果：
rec_id No name
003 Y 101 材料1
005 Y102 材料2
006 Y103 材料3
007 Y104 材料4
请问如何写SQL语句
select * from 表名 where destinct name
select * from 表名 where destinct name order by rec_id asc
select max(rec_id),No, name from 表名 group by No, name
select * from (select * from 表 order by rec_id desc) T group by name order by rec_id
select distinct max(rec_id) over(partition by No,name ),No,name from 表名
select distinct max(rec_id) over(partition by No,name ),No,name from 表名
select distinct max(rec_id) over(partition by No,name ),No,name from 表名
SELECT rec_id,No,name FROM tb a WHERE NOT EXISTS(SELECT 1 FROM tb WHERE a.NO=b.NO AND rec_id>a.rec_id )
select max(rec_id),No, name from 表名 group by No, name order by No;