Hi,
I had to find 5th incident type id from cs_incident_types_tl table. So I was googling for a SQL query to find Nth row in an Oracle table
and found the below example
SELECT a.incident_type_id
FROM cs_incident_types_tl A
WHERE 5 = (SELECT COUNT (b.incident_type_id)
FROM cs_incident_types_tl B
WHERE a.incident_type_id<=b.incident_type_id)
But I am unable to understand how the query is functioning.
So i would appreciate any help from you experts if you could explain the execution/functioning of this query.