Finding a record number using SQL

I would like to find the relative record number of a specific record using a
query. I need to use an order by clause and where lname = somelastname.

It seems like you use something with count(*) > 0 but I cannot remember?

Thanks!


.