I’ve grown up reading Tom Clancy and probably most of you have at least seen Red October, so this book caught my eye when browsing used books for a recent trip. It’s a fairly human look at what’s involved in sailing on a Trident missile submarine…
you can use DENSE_RANK() function.Here i show some example that show results
and i hope clear concept about ranking functions
in SQL Server:
rownumber of each row of result set.
value_expression , … [ n ] ] order_by_clause )
rank of rows within the partition of a result set, without any gaps in the
Returnsthe rank of each row within the partition of a
OVER ( [
partition_by_clause ] order_by_clause )
used for this purpose because it provide a number for same values.