I would use
SELECT id FROM table ORDER BY id LIMIT 0, 3;
in order to get the top 3 results. The key is Limit keyword.
==
Wei Weng
Network Software Engineer
KenCast Inc.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Yoann
Sent:
- Original Message -
From: trebischt [EMAIL PROTECTED]
Subject: [SQL] To query many tables.
Hi,
The query looks like this:
select * from table1 f, table2 s, table3 t, table4 fo, table5 fi,
table6 si, table 7 se, table8 e, table9 n, table10 ten, table 11 el,
table 12 tw ...
where
[ Sorry for slow response, I've been out of town ]
Robert J. Sanford, Jr. [EMAIL PROTECTED] writes:
[ some questions already ably answered by Josh and Stephan ]
I just wanted to throw in one more tidbit:
for example, one thing that one of my friends said is:
select X
from big_table