RE: [PHP-WIN] SQL to select a set of records
| From: | Frank M. Kromann | Date: | Fri, 06 Feb 2004 16:15:55 +0000 |
| Subject: | RE: [PHP-WIN] SQL to select a set of records | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-22749@lists.php.net to get a copy of this message | ||
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))
>
>
> 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')
> insert into test values (7, 'd')
> insert into test values (8, 'd')
> insert into test values (9, 'e')
> insert into test values (10, 'e')
> insert into test values (11, 'e')
> insert into test values (12, 'e')
> insert into test values (13, 'e')
> insert into test values (14, 'e')
> insert into test values (15, 'e')
> insert into test values (16, 'e')
> insert into test values (17, 'e')
> insert into test values (18, 'e')
> insert into test values (19, 'e')
> insert into test values (20, 'e')
> insert into test values (21, 'e')
> insert into test values (22, 'e')
> insert into test values (23, 'e')
> insert into test values (24, 'e')
> insert into test values (25, 'e')
> insert into test values (26, 'e')
> insert into test values (27, 'e')
> insert into test values (28, 'e')
> insert into test values (29, 'e')
> insert into test values (30, 'e')
>
> insert into test_tmp
> select top 25 *
> from test
> order by a asc
>
> select *
> from test_tmp
> where a in(
> select top 15 a
> from test_tmp
> order by a desc
> )
> order by a asc
>
> drop table test_tmp
> drop table test
>
>
>
>
> -----Original Message-----
> From: Stuart
> To: David Felton
> Cc: Nadim Attari; php-windows@lists.php.net; Herhuth, Ron
> Sent: 2004-02-06 13:44
> Subject: Re: [PHP-WIN] SQL to select a set of records
>
> 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
> FROM dbo.Table_MIS_Files
> WHERE dbo.Table_MIS_Files.File_ID NOT IN
> (SELECT TOP 10 dbo.Table_MIS_Files.File_ID
> FROM dbo.Table_MIS_Files)
>
> That will get rows 11-25.
> --
> Stuart
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>