Pull a Top n Record From Oracle

[VBAHole22]

I need to run a query against Oracle that returns a set of records but I only care about the top one (it's ordered). How can I get this one record back?

 

Right now I am using a datareader and not using the While dr.Read syntax. I think this is giving me the first record but I'm unsure if it is the best way to do it.

 

Any suggestions?

[Derek Stone]

http://www.orafaq.com/faqsql.htm#TOP

[VBAHole22]

Sweet.

 

SELECT *

FROM (SELECT AField FROM my_table ORDER BY col_name_1 DESC)

WHERE ROWNUM < 10;

 

 

Now I can use a command and ExecuteScalar.

 

Tank you.