Database

SELECT a.* 
FROM a 
   INNER JOIN (SELECT id, Max(edt) AS edt FROM a GROUP BY id)b 
                           ON a.id = b.id AND a.edt = b.edt
ORDER BY a.id

DECLARE @nth as bigint
SET @nth = 10

SELECT * 
FROM TblA AS a 
WHERE @nth = (SELECT COUNT(ColA) 
              FROM TblB AS b 
              WHERE b.ColA >= a.ColA)

DECLARE @nth as bigint
SET @nth = 2

SELECT * 
FROM TblA AS a 
	WHERE @nth = (SELECT Distinct Count(*) 
		      FROM TblA AS b 
		      WHERE b.EDate >= a.EDate AND b.id = a.id)

SELECT     ID, MAX(value1) AS value1<br />
FROM         tableName<br />
GROUP BY ID

SELECT *<br />
FROM SOMEWHERE <br />
WHERE nameofperson LIKE a%<br />
AND nameofperson LIKE b%<br />
AND nameofperson LIKE c%<br />
AND nameofperson LIKE d%

select * from somewhere where nameofperson like '[ABCDEF]%'