USE Poliklinika;
GO

--SELECT L.datnar FROM Lekari L
--	ORDER BY L.datNar DESC	-- 5r: 1980//1970//1961//1960//1956

-- F1) Vratte prvych troch najmladsich
SELECT TOP(3) L.datnar FROM Lekari L
	ORDER BY L.datNar DESC

-- F2) Usporiadajte lekarov podla veku zostupne a
--     vratte aj ciselnik ~ poradie.
SELECT krstne, datNar
	   , ROW_NUMBER() OVER(ORDER BY datnar DESC) AS ciselnik
	   , RANK()		  OVER(ORDER BY datnar DESC) AS ciselnik
	FROM Lekari

-- F3) Vratte tretieho/u najmladsieho/u lekara/ku:
SELECT * FROM
		(SELECT krstne, datNar
				, ROW_NUMBER() OVER(ORDER BY datnar DESC) AS ciselnik
			FROM Lekari
		) T
	WHERE T.ciselnik BETWEEN 3 AND 3
	----WHERE T.poradie BETWEEN 3 AND 4