Sorting and retrieving data in sqlserver

SQL Server's question about data sorting: SELECT * FROM (SELECT *, row_number () OVER (PARTITIONBYwok. flag_3ORDERBYwok.createtimedesc) rownumFROM (selectworkh. corp_code, workh. corp_name, workh. begin_date, workh. createtime, workh. flag_1, workh. fla

SQL Server's question about data sorting: SELECT * FROM (SELECT *, row_number () OVER (PARTITION BY wok. flag_3 order by wok. createtime desc) rownum FROM (select workh. corp_code, workh. corp_name, workh. begin_date, workh. createtime, workh. flag_1, workh. fla

SQL Server's question about data sorting

SELECT * FROM (SELECT *, row_number () OVER (partition by wok. flag_3 order by wok. createtime desc)

Rownum FROM (select workh. corp_code, workh. corp_name, workh. begin_date, workh. createtime,

Workh. flag_1, workh. flag_2, workb. main_id, workb. production_quantity, workb. spare_capacity,

Workb. equipment_code, workb. flag_3 from imp_workorderh workh right join imp_workorderb workb

On workb. main_id = workh. id where workh. teachingplanid = '{aa10000000016f6u') wok) h WHERE h. rownum = 1)

This query is sorted in inverted chronological order and then the data with rownum 1 is retrieved. The specific situation can be modified as needed.

,