I need to count the total number of rows in a table before the certain row ID.
I have this query
select count (ClientID)
FROM [Seek].[dbo].[seekClient]
where ClientID < '12'
which works fine for the case of integer primary key, but I am not sure how to do that in case of GUID ??
Kindly help me in this case.
Thanks
Pravesh Singh
03-Feb-2014You should use a different column (not id) that defines what you mean by 'before'. It might be, for example, a 'DateOfCreation', 'creation_date' etc. column.