Database

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]%'

DataRow[] rows = myDataTable.Select("Column1 = 25","column1 asc")