Database

select distinct organisation,<br />
(select top 1 t1.rerportyear from myTable as t1 where t1.organisation = myTable.organisation order by rerportyear desc) as reportYear,income,expenditure<br />
from myTable 

SELECT<br />
	Organization,<br />
	[Report Year],<br />
	[Income],<br />
	[Expenditure]<br />
FROM <br />
	Table1 a <br />
WHERE [Report Year] >=<br />
		(<br />
		SELECT TOP 1 <br />
			[Report Year]<br />
		FROM <br />
			Table1 b <br />
		WHERE <br />
			a.Organization = b.Organization <br />
		ORDER BY [Report Year] DESC<br />
		)<br />
ORDER BY <br />
	Organization

select distinct cola <br />
from myTable<br />
union all<br />
select distinct colb from myTable where colb <> (select top 1 cola from myTable order by cola desc)<br />
union all<br />
select distinct t3.colc from myTable as t3 where t3.colc <='z' and t3.colc >(select top 1 colb from myTable order by colb desc)

select distinct cola <br />
from myTable<br />
union all<br />
select distinct colb from myTable where colb <> (select top 1 cola from myTable order by cola desc)<br />
union all<br />
select distinct t3.colc from myTable as t3 <br />
where t3.colc <=(select top 1 colc from myTable order by colc desc)<br />
and t3.colc >(select top 1 colb from myTable order by colb desc) 

USE northwind<br />
<br />
DECLARE @MaxStock SMALLINT<br />
DECLARE @NextMaxStock SMALLINT<br />
<br />
SELECT <br />
	@MaxStock = MAX(UnitsInStock) <br />
FROM <br />
	PRODUCTS<br />
<br />
SELECT <br />
	@MaxStock<br />
<br />
SELECT <br />
	@NextMaxStock = MAX(UnitsInStock) <br />
FROM<br />
	PRODUCTS <br />
WHERE	<br />
	UnitsInStock < @MaxStock<br />
<br />
SELECT <br />
	@NextMaxStock<br />
<br />
SELECT <br />
	@MaxStock + @NextMaxStock<br />