Tech Mahindra interview question

They asked about the Limit query in sql