Password <br /><input type="password" name="passwd" id="passwd" class="inputbox" size="18" alt="password" />

TOP

- Note:

1 2	SELECT TOP number\|percent column_name(s) FROM table_name

1
2
3

SELECT column_name(s)
FROM table_name
LIMIT number

1
2
3

SELECT *
FROM Persons
LIMIT 5

1
2
3

SELECT column_name(s)
FROM table_name
WHERE ROWNUM <= number

1
2
3

SELECT *
FROM Persons
WHERE ROWNUM <=5

SQL TOP

There is a table "Persons":

P_Id	LastName	FirstName	Address	City
1	Hansen	Ola	Timoteivn 10	Sandnes
2	Svendson	Tove	Borgvn 23	Sandnes
3	Pettersen	Kari	Storgt 20	Stavanger
4	Nilsen	Tom	Vingvn 23	Stavanger

1	SELECT TOP 2 * FROM Persons

Query Result:

P_Id	LastName	FirstName	Address	City
1	Hansen	Ola	Timoteivn 10	Sandnes
2	Svendson	Tove	Borgvn 23	Sandnes

There is a table "Persons":

P_Id	LastName	FirstName	Address	City
1	Hansen	Ola	Timoteivn 10	Sandnes
2	Svendson	Tove	Borgvn 23	Sandnes
3	Pettersen	Kari	Storgt 20	Stavanger
4	Nilsen	Tom	Vingvn 23	Stavanger

1	SELECT TOP 50 PERCENT * FROM Persons

Query Result:

P_Id	LastName	FirstName	Address	City
1	Hansen	Ola	Timoteivn 10	Sandnes
2	Svendson	Tove	Borgvn 23	Sandnes

-7 #1 villian 2010-06-09 11:24 Some databases support only multiples of ten and five arguments. Ie , ... Well you get the idea. Quote

+6 #2 Irina 2010-10-20 08:35

Some databases support only multiples of ten and five arguments. Ie , ... Well you get the idea.

and which support the TOP 2 TOP for example? Quote

Address
E-mail	ageent.ua @ gmail.com ageent.ru @ gmail.com
Phone	Mobile: +380 54 501 90 28
Websites	Print