Find Nth column of the Particular Table – Query to Retrieve the Nth value

SELECT TOP 1 *
    FROM (
            SELECT TOP 3 *,ROW_NUMBER() OVER ( ORDER BY ColumnNameBasedOnWhichOrder DESC) AS RowNum
            FROM TableName
        )a 
ORDER BY
    a.RowNum ASC

SELECT TOP 1 ColumnDetailID
FROM (
SELECT DISTINCT TOP 6 ColumnDetailID
FROM TableName
ORDER BY ColumnDetailID DESC) a
ORDER BY ColumnDetailID


SELECT TOP 1 ColumnDetailID
FROM
(
    SELECT TOP 3 ColumnDetailID
    FROM TableName
    ORDER BY ColumnDetailID DESC
) SalarySubquery
ORDER BY ColumnDetailID ASC