I have a table and I need to determine if there is more than one record for an employee. Is it faster to set a filter based on that employee and check the record count or create a query into a cursor?

Also if I filter based on the employee, will that affect the sort order? Will the first record for the employee that appears in the table as it is sorted still be the first one?

If I query into a cursor, there is a chance that it may not be sort the same way unless I specify a sort order, correct?

Thank you