Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

select top 1 row from query results

627631Mar 11 2008 — edited Mar 11 2008
How can i select only top 1 row from the results obtained from a database query?
My query looks some thing like this..
select col1,col2 from table1
inner join table2 on
table1.id = table2.id
order by col2.
I get around 100 rows returned, but i want to have only top one column.
How can limit this.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2008
Added on Mar 11 2008
4 comments
5,366 views