select min(your_field) from your_table where your_field NOT IN (select distinct TOP 1 your_field from your_table ORDER BY your_field DESC)
SELECT TOP 1 Fees FROM ( select top 2 * from table order by Fees ASC ) AS Table ORDER BY Fees DESC
Select MIN(Sal) From TableName Where Sal > (Select MIN(sal) From TableName)
select top 1 ColumnName from TableName where ColumnName not in (select top 1 ColumnName from TableName order by ColumnName asc)
select top 1 id from std where id not in (select top 1 id from std order by id asc )
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)