Database

deep7 wrote:

i can't get how to do this..could any one plz help me out here

SELECT TOP 2 * 
FROM MyTable 
ORDER BY [date] DESC

SELECT TOP 1 * 
FROM MyTable 
ORDER BY [date] DESC;
 
SELECT TOP 1 * 
FROM MyTable 
WHERE [date] NOT IN(SELECT MAX([date]) FROM MyTable)
ORDER BY [date] DESC;

<br />
select	e1.EmployeeID, e1.BirthDate, <br />
		cast(e1.BirthDate-(<br />
			select	top 1 e2.BirthDate<br />
			from	HumanResources.Employee e2<br />
			where	e2.BirthDate<e1.BirthDate<br />
			order by e2.BirthDate desc<br />
		) as float)<br />
from	HumanResources.Employee e1<br />
order by e1.BirthDate desc<br />

SELECT * from FDetails where ddate = #05/29/2006#

SELECT tbl2.col1
FROM tbl1
INNER JOIN tbl2 ON tbl1.tbl2FK = tbl2.PK
INNER JOIN tbl3 ON tbl1.tbl3FK = tbl3.PK.....

SELECT InterimRentReceivableUpfrontTaxModeName
FROM InventoryProfile
INNER JOIN TaxModes 
    ON TaxModes.ID = InventoryProfile.InterimRentReceivableUpfrontTaxModeID