2 sql questions

[Anon]

1. I want to select top 5 results/rows, in Microsoft SQL, I can use

Select Top 5 * from mytable where year="2002" order by lastname.

My questions are:

1) Select Top 5 ... is that SQL standard for other general SQL database? Specially for Interbase? I tried it in Interbase, it gave me error message. And I checked my SQL reference book, it is not in there.

2) If I want to select the results 10-15m how do I do it?

3) If "Select Top 5 " is not used in Interbase etc, how can select the top 5 rows in SQL then?

2. use "Select CustNumber, Name from Mytable" SQL

later on, I can use

$name=$ROW->NAME; to get the name values.

but if i use "SELECT COUNT (CustNumber) from Mytable"

how can i get the count value? Should I change the SQL to "SELECT COUNT (CustNumber) AS totalnumber from Mytable"

and then later on

$count=$ROW->TOTALNUMBER; TO GET THE COUNT?

THANKS!

[Anon]

in the question i mean

2) If I want to select the results/rows 10th-15th, how do I do it?

[trooper]

Hui

THe string "SELECT TOP 5..." looks like a T/SQL statement. (Microsoft's version of SQL)

In generic sql you'd use SELECT * from Mytable where year="2002" order by year LIMIT 5.

[Anon]

Gary:

SELECT * from Mytable where year="2002" order by year LIMIT 5.

is not working.

I also tried

Set ROWCOUNT 5
Select * from mytable

not work either

These are SQL used by certain Databases, not all, Right?

Thanks.

Hui

[Anon]

in interbase it will be ROWS CLAUSE for this purpose