Re: [GENERAL] Query

[Mitch Vincent]

>     I'm trying to execute the following query:
>         "SELECT TOP 10 * FROM table1"

SELECT * FROM table1 LIMIT 10

 -- might give you what you're looking for.. I've not seen TOP, though I
could guess where it comes from (Oracle?) -- top seems to imply order so you
might want to ORDER BY something in the query before you LIMIT ...

-Mitch



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html