Oracle 从多条符合条件的记录中选择一条显示
SELECT
ti.*
FROM
(
SELECT
pt.*,
ROW_NUMBER() OVER(
PARTITION BY pt.test_item_name
ORDER BY
pt.test_item_id
) row_id
FROM
t_procedure_test pt
WHERE
pt.model_code = '1001000058611'
) ti
WHERE
row_id = 1;