Hee Venkateshkumar K,
You can use the offset and amount when you want to find a specific record set the amount on 1 and the offset on the index of the specified record.
Also the retrieve from database has these two fields to use;
more info can be found here:
https://docs.mendix.com/refguide/list-operation/
Hope this helps,
Good luck!