Controlling Reuslts with Limit
| От | Najm Hashmi |
|---|---|
| Тема | Controlling Reuslts with Limit |
| Дата | |
| Msg-id | 3A9822F2.FF9437C9@mondo-live.com обсуждение исходный текст |
| Ответы |
Re: Controlling Reuslts with Limit
Re: Controlling Reuslts with Limit Re: Controlling Reuslts with Limit Re: Controlling Reuslts with Limit |
| Список | pgsql-sql |
Hi,
I was reading through Bruce's on line . I found follwing bit unclear...
"Notice that each query uses ORDER BY . Although this clause is not required,
LIMIT without ORDER BY returns random rows from the query, which would be
useless. "
When I run a query several time I get the same results as given
flipr=# select song_id from songs limit 5;
song_id
---------
945
946
947
948
949
(5 rows)
flipr=# select song_id from songs limit 5;
song_id
---------
945
946
947
948
949
(5 rows)
flipr=# select song_id from songs limit 5;
song_id
---------
945
946
947
948
949
(5 rows)
flipr=# select song_id from songs limit 5;
song_id
---------
945
946
947
948
949
(5 rows)
flipr=# select song_id from songs limit 5;
song_id
---------
945
946
947
948
949
(5 rows)
flipr=# select song_id from songs limit 5;
song_id
---------
945
946
947
948
949
I just want to know what exatly --"LIMIT without ORDER BY returns random rows
from the query" --means
Regards
Вложения
В списке pgsql-sql по дате отправления: