On Sat, Oct 25, 2003 at 08:23:56AM +0300, cristi wrote: > Cum pot face selectia penulitemelor (sau antepenultimele etc) 10 > inregistrari dintr-o tabela? > Nu pot face deocamdata decat selectia primelor 10 si ultimelor 10 > integistrari. > > select * from nume_tabela limit 10; SELECT * FROM tabela LIMIT 10 OFFSET 10; Vezi ca trebuie sa le si ordonezi intr-un fel... Te prinzi tu. Daca vrei 'quick reference' la comenzile SQL din PostgreSQL si esti in psql, \h <comanda>. Daca nu, http://www.postgresql.org/docs/7.3/interactive/sql-commands.html
HTH -- Birzan George Violence is the last refuge of Cristian the incompetent -- Salvor Hardin -- Attached file included as plaintext by Ecartis -- -- File: signature.asc -- Desc: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQE/mgw7aqNK6cml/6cRAkBaAJwJvKpaZDIM4SqWyDSs0BIYOj/mVQCfbO7O MV8bZUeUkCsloSQ7EORmnyo= =VTO5 -----END PGP SIGNATURE----- --- Detalii despre listele noastre de mail: http://www.lug.ro/
