Not quite true.
>From the manuals :
The LIMIT clause can be used to constrain the number of rows returned by the
SELECT statement. LIMIT takes one or two numeric arguments. If two arguments
are given, the first specifies the offset of the first row to return, the
second specifies the maximum numb
php-windows Digest 6 Feb 2004 08:50:36 - Issue 2109
Topics (messages 22737 through 22741):
Re: Problem with form
22737 by: John Ellingsworth
22738 by: Disko_kex
SQL to select a set of records
22739 by: Herhuth, Ron
22740 by: Svensson, B.A.T. (HKG)
227
> mysql> select * from table LIMIT 5,10; # Retrieve rows 6-15
> If one argument is given, it indicates the maximum number of rows to
return:
> mysql> select * from table LIMIT 5; # Retrieve first 5 rows
Dunno whether LIMIT works in Microsoft SQL Server ... someone may check it
plzzz
~nadim
I have both access and MySQL DBs and I have to change my method for Access
to 'select top 10 [fields] from table where x=x etc order by y'
MS SQLServer may need the same.
George in Oxford
> -Original Message-
> From: Nadim Attari [mailto:[EMAIL PROTECTED]
> Sent: 6 February 2004 11:33 am
No it doesn't. you'll need to do something like this in MS-SQL (using a
sub-select):
SELECT TOP 10 dbo.Table_MIS_Files.File_ID
FROMdbo.Table_MIS_Files
WHERE dbo.Table_MIS_Files.File_ID NOT IN
(SELECT TOP 25 dbo.Table_MIS_Files.File_ID
FROMdbo.Table_MIS_Files)
-Ori
David Felton wrote:
SELECT TOP 10 dbo.Table_MIS_Files.File_ID
FROM dbo.Table_MIS_Files
WHERE dbo.Table_MIS_Files.File_ID NOT IN
(SELECT TOP 25 dbo.Table_MIS_Files.File_ID
FROM dbo.Table_MIS_Files)
Shouldn't this be...
SELECT TOP 25 dbo.Table_MIS_Files.File_ID
FROMdbo.Table_MIS_F
I tried to start an asyncroniously job on a win2003 server with php 4.3.4
(november build) with system("start ...") and passthru("start ...") however
it turns out that the php call is waiting until completion of the command
that starts invoke..
Thinking about it, it seams like start does fork a bi
set nocount on
create table test (a int , b char(1))
create table test_tmp (a int , b char(1))
insert into test values (1, 'a')
insert into test values (2, 'a')
insert into test values (3, 'b')
insert into test values (4, 'b')
insert into test values (5, 'c')
insert into test values (6, 'c'
Okay I tried this and while it doesn't error out I still only get the
first 10 records, if I change the first number I get the number of records
that I changed the number to. If I change the second number nothing
happens.
SELECT TOP 10 dbo.individual.id, last_name, first_name
FROM dbo.individua
create table #test (a int , b char(1))
create table #test_tmp (a int , b char(1))
Would make these tables real temp tables. These will be deleted wehn the
connection is closed.
- Frank
> set nocount on
> create table test (a int , b char(1))
> create table test_tmp (a int , b char(1))
>
>
> i
No. What I said was correct, as Ron wanted rows 25-35.
-Original Message-
From: Stuart [mailto:[EMAIL PROTECTED]
Sent: 06 February 2004 12:45
To: David Felton
Cc: Nadim Attari; [EMAIL PROTECTED]; Herhuth, Ron
Subject: Re: [PHP-WIN] SQL to select a set of records
David Felton wrote:
> SEL
It doesn't matter neither one works...they only bring back the first x
number of records.
Ron
>From: David Felton
>To: Stuart
>Sent: 02/06/2004 11:24 AM
>No. What I said was correct, as Ron wanted rows 25-35.
>
>-Original Message-
>From: Stuart [mailto:[EMAIL PROTECTED]
>Sent: 06 February
I have a problem with starting sessions on my site. Lets say someone comes
from site random.com but the link they click on to get to my site has a
?sessid=gobildygook in its href. The way things are now, the session starts
right up using the sessid saved in their href. I suppose this could also
php-windows Digest 7 Feb 2004 01:09:50 - Issue 2110
Topics (messages 22742 through 22752):
Re: SQL to select a set of records
22742 by: Nadim Attari
22743 by: George Pitcher
22744 by: David Felton
22745 by: Stuart
22747 by: Svensson, B.A.T. (HKG)
14 matches
Mail list logo
