oracle sql select

[malayalam]

How to retrieve the 5 maximum salaries from the employee table.

 

[foxdev]

[tt]select top 5 * from mytable
order by salary desc[/tt]

I have no idea why you titled your post Oracle SQL Select, since this is the Microsoft SQL Server forum; hopefully, though, I've answered your question.

Robert Bradley

http://www.foxdev.com/

 

[culshaja]

If I am right then this will not work in Oracle as the TOP keyword doesn't seem to exist. At least it doesn't appear in the Complete Oracle Reference...

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[uncleroydee]

I will soon be creating a DTS package that will include a Select statement from an Oracle database. If anyone has suggestions for tips and pitfalls I would be grateful.

Roy