From: | "Daniel Caune" <daniel(dot)caune(at)ubisoft(dot)com> |
---|---|
To: | "Michael Glaesemann" <grzm(at)myrealbox(dot)com>, "min" <seedbcc(at)a-qe(dot)com> |
Cc: | "postgresql sql list" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Ask a PostgreSql question (about select ) |
Date: | 2006-03-13 14:21:41 |
Message-ID: | 1E293D3FF63A3740B10AD5AAD88535D201C34459@UBIMAIL1.ubisoft.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
> Objet : Re: [SQL] Ask a PostgreSql question (about select )
>
> Please post questions to the list. I'm forwarding this to the SQL
> list, as I think it's probably most applicable. I don't know much
> about the Oracle syntax you've used. Hopefully someone will be able
> to help you.
>
> On Mar 13, 2006, at 12:30 , min wrote:
>
> > Please help me one PostgreSQL Statement, Thanks
> >
> > in Oracle
> > select rownum,groupid,qty from abc
> > --- --- ----
> > 1 a5 3
> > 2 a2 4
> > 3 a3 5
> > 4
> > 5
> > .
> > .
> > .
> >
> >
> > in PostgreSql
> >
> > How to wirte Statement ( Rownum -> change ??)
> >
PostgreSQL doesn't have the Oracle ROWNUM feature. But if you were using ROWNUM to limit a result set, you are more likely to use the LIMIT feature in PostgreSQL:
http://archives.postgresql.org/pgsql-sql/2005-05/msg00127.php
--
Daniel
From | Date | Subject | |
---|---|---|---|
Next Message | Rod Taylor | 2006-03-13 14:33:12 | Re: Permission to Select |
Previous Message | Robert Urban | 2006-03-13 13:07:03 | removing "not null" modifier |