Selecting a single row through sql

[peter_poulsen]

I have a ODBC connection to a Progress DB, and I need the first row of my table. How do I get that using SQL? (Actually it does not have to be the first row, any row will do). In MySQL I would do it like this:

SELECT * FROM myTable LIMIT 1;

but that does not seem to work with Progress (I think limit is MySQL specific).

Yours
Peter Poulsen

 

[solcase]

you could try



select * from pub.mytable where rowid in
(select min(rowid) from pub.mytable)