ajanuskevicius
5/24/2017 - 2:17 PM

To Get N-th Data Row

To Get N-th Data Row

(
SELECT p.Description 
FROM tt_eMedications m 
  LEFT OUTER JOIN tts_pickListItems p ON m.MedicationID = p.id 
WHERE m.MasterIncidentID = tt_MasterIncident.MasterIncidentID 
ORDER BY m.MedicationsID 
LIMIT 3,1
)