select ID,NAME,SCOPE
FROM (NAME,SCOPE) IN (SELECT NAME,MAX(SCOPE) FROM TAB GROUP BY NAME )

------解决方案--------------------

select * from tab a
where not exists(select 1 from tab b where a.name=b.name and a.scope<b.scope)

------解决方案--------------------
SQL code
SELECT ID, NAME, SCOPE
  FROM TAB
 WHERE (NAME, SCOPE) IN  SELECT NAME, MAX(SCOPE) FROM TAB GROUP BY NAME

------解决方案--------------------
探讨

SQL code
SELECT ID, NAME, SCOPE
  FROM TAB
 WHERE (NAME, SCOPE) IN  SELECT NAME, MAX(SCOPE) FROM TAB GROUP BY NAME