forum

Home / DeveloperSection / Forums / How to count number of rows before an ID in SQL Server

How to count number of rows before an ID in SQL Server

Anonymous User181403-Feb-2014

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


Updated on 03-Feb-2014
I am a content writter !

Can you answer this question?


Answer

1 Answers

Liked By