SQL Server or Oracle queries the top three questions for each section

SELECT *  from(SELECT [pk_event_report_id]      ,[fk_report_flow_id]      ,[Event_report_kind]      ,[Event_report_type]      ,[event_report_org]      ,[Event_report_number], Dense_rank () Over(Partition byevent_report_orgORDER  by [event_report_sumit_date] DESC) asROWNUM1 from [gcsdb_2].[dbo].[Event_reports]) TTWHEREROWNUM1<2

First step group sorting, plus numbering, second step to delete

Oracle is similar, except that the Add function is different

SELECT * FROM (
Select  t.*,row_number () over (partition by t.subject_no ORDER by t.score Desc) pm from score T) where pm<4;

Oracle is numbered with Row_number.

SQL Server or Oracle queries the top three questions for each section