CREATE VIEW v_test
AS
SELECT TOP 100 PERCENT COUNT(*) as Rank, a1.au_lname, a1.au_fname
FROM authors a1 INNER Join authors a2
ON a1.au_lname + a1.au_fname >= a2.au_lname + a2.au_fname
GROUP BY a1.au_lname, a1.au_fname
ORDER BY 1
go
ولی توصیه میکنم از این روش استفاده نکنید
