"select top 4 * from table" in TSQL (SQL server..) or "select * from table
limit (0, 4)" in SQL92 (everything else)

Chris

----- Original Message -----
From: "Marios Adamantopoulos" <mario@T...>
To: "sql language" <sql_language@p...>
Sent: Thursday, March 22, 2001 10:05 PM
Subject: [sql_language] SQL the first four


> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
>
> ------_=_NextPart_001_01C0B2D1.6107DA6C
> Content-Type: text/plain;
> charset="utf-7"
>
>
> Is there a way to select the first four entries of a column
>
> using SQL?
> +AF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBf-
> Marios Adamantopoulos
> Web Developer
>
> Tonic Design Limited
> Studio 2, Church Studios
> Camden Park Road
> London NW1 9AY
>
> Tel +-44 (0)20 7691 2227
> Fax +-44 (0)20 7691 2228
> Mob +-44(0)7904 221 663
>
> www.tonicdesign.co.uk
>
............................................................................
> ....................................
> Opinions, conclusions and other information in this message
> that do not relate to the official business of Tonic Design Ltd
> shall be understood as neither given nor endorsed by them.
>
............................................................................
> ....................................
>
>
> -----Original Message-----
> From: Ivan +AFs-mailto:ivanv+AEA-waldonet.net.mt+AF0-
> Sent: 22 March 2001 18:14
> To: ASP Databases
> Subject: +AFs-asp+AF8-databases+AF0- How many users at a time access
accepts
>
>
> can someone tell me how many users at a time Ms Access accepts.  I have
> heard 255 but in reality is this real, or at-least in ASP.
>
> Is ms Fox-Pro better than access for web development?
>
> Thanks
>
>
> ---
> SoftArtisans helps developers build robust, scalable Web applications+ACE-
> Excel Web reports, charts: http://www.softartisans.com/excelwriter.html
> File uploads: http://www.softartisans.com/saf.html
> Transactional file management: http://www.softartisans.com/saf1.html
> Scalability: http://www.softartisans.com/saxsession.html
> ASPstudio value pack: http://www.softartisans.com/aspstudiosuite.html
mario+AEA-tonicdesign.co.uk
> leave-asp+AF8-databases-477561D+AEA-p2p.wrox.com
>
> ------_=_NextPart_001_01C0B2D1.6107DA6C
> Content-Type: text/html;
> charset="utf-7"
> Content-Transfer-Encoding: quoted-printable
>
> +ADwAIQ-DOCTYPE HTML PUBLIC +ACI--//W3C//DTD HTML 3.2//EN+ACIAPg-
> +ADw-HTML+AD4-
> +ADw-HEAD+AD4-
> +ADw-META HTTP-EQUIV+AD0AIg-Content-Type+ACI- 
> CONTENT+AD0AIg-text/html+ADs- charset+AD0-utf-7+ACIAPg-
> +ADw-META NAME+AD0AIg-Generator+ACI- CONTENT+AD0AIg-MS Exchange Server 
> version 5.5.2448.0+ACIAPg-
> +ADw-TITLE+AD4-SQL the first four+ADw-/TITLE+AD4-
> +ADw-/HEAD+AD4-
> +ADw-BODY+AD4-
> +ADw-BR+AD4-
>
> +ADw-P+AD4APA-FONT SIZE+AD0-2+AD4-Is there a way to select the first 
> four entries of a column+ADw-/FONT+AD4-
> +ADw-/P+AD4-
>
> +ADw-P+AD4APA-FONT SIZE+AD0-2+AD4-using SQL?+ADw-/FONT+AD4-
> +ADw-BR+AD4APA-FONT 
> SIZE+AD0-2+AD4AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AP
> A-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4-Marios Adamantopoulos+ADw-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4-Web Developer+ADw-/FONT+AD4-
> +ADw-/P+AD4-
>
> +ADw-P+AD4APA-FONT SIZE+AD0-2+AD4-Tonic Design Limited+ADw-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4-Studio 2, Church Studios 
> +ADw-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4-Camden Park Road+ADw-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4-London NW1 9AY+ADw-/FONT+AD4-
> +ADw-/P+AD4-
>
> +ADw-P+AD4APA-FONT SIZE+AD0-2+AD4-Tel +-44 (0)20 7691 
> 2227+ADw-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4-Fax +-44 (0)20 7691 
> 2228+ADw-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4-Mob +-44(0)7904 221 
> 663+ADw-/FONT+AD4-
> +ADw-/P+AD4-
>
> +ADw-P+AD4APA-FONT SIZE+AD0-2+AD4-www.tonicdesign.co.uk+ADw-/FONT+AD4-
> +ADw-BR+AD4APA-FONT 
> SIZE+AD0-2+AD4-.........................................................
> .......................................................+ADw-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4-Opinions, conclusions and other 
> information in this message +ADw-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4-that do not relate to the official 
> business of Tonic Design Ltd +ADw-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4-shall be understood as neither given 
> nor endorsed by them.+ADw-/FONT+AD4-
> +ADw-BR+AD4APA-FONT 
> SIZE+AD0-2+AD4-.........................................................
> .......................................................+ADw-/FONT+AD4-
> +ADw-/P+AD4-
> +ADw-BR+AD4-
>
> +ADw-P+AD4APA-FONT SIZE+AD0-2+AD4------Original 
> Message-----+ADw-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4-From: Ivan +AFsAPA-A 
> HREF+AD0AIg-mailto:ivanv+AEA-waldonet.net.mt+ACIAPg-mailto:ivanv+AEA-wal
> donet.net.mt+ADw-/A+AD4AXQA8-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4-Sent: 22 March 2001 
> 18:14+ADw-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4-To: ASP Databases+ADw-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4-Subject: +AFs-asp+AF8-databases+AF0- 
> How many users at a time access accepts+ADw-/FONT+AD4-
> +ADw-/P+AD4-
> +ADw-BR+AD4-
>
> +ADw-P+AD4APA-FONT SIZE+AD0-2+AD4-can someone tell me how many users at 
> a time Ms Access accepts.+ACY-nbsp+ADs- I have +ADw-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4-heard 255 but in reality is this 
> real, or at-least in ASP.+ACY-nbsp+ADs- +ADw-/FONT+AD4-
> +ADw-/P+AD4-
>
> +ADw-P+AD4APA-FONT SIZE+AD0-2+AD4-Is ms Fox-Pro better than access for 
> web development?+ADw-/FONT+AD4-
> +ADw-/P+AD4-
>
> +ADw-P+AD4APA-FONT SIZE+AD0-2+AD4-Thanks+ADw-/FONT+AD4-
> +ADw-/P+AD4-
> +ADw-BR+AD4-
>
> +ADw-P+AD4APA-FONT SIZE+AD0-2+AD4----+ADw-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4-SoftArtisans helps developers build 
> robust, scalable Web applications+ACEAPA-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4-Excel Web reports, charts: +ADw-A 
> HREF+AD0AIg-http://www.softartisans.com/excelwriter.html+ACI- 
> TARGET+AD0AIgBf-blank+ACIAPg-http://www.softartisans.com/excelwriter.htm
> l+ADw-/A+AD4APA-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4-File uploads: +ADw-A 
> HREF+AD0AIg-http://www.softartisans.com/saf.html+ACI- 
> TARGET+AD0AIgBf-blank+ACIAPg-http://www.softartisans.com/saf.html+ADw-/A
> +AD4APA-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4-Transactional file management: 
> +ADw-A HREF+AD0AIg-http://www.softartisans.com/saf1.html+ACI- 
> TARGET+AD0AIgBf-blank+ACIAPg-http://www.softartisans.com/saf1.html+ADw-/
> A+AD4APA-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4-Scalability: +ADw-A 
> HREF+AD0AIg-http://www.softartisans.com/saxsession.html+ACI- 
> TARGET+AD0AIgBf-blank+ACIAPg-http://www.softartisans.com/saxsession.html
> +ADw-/A+AD4APA-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4-ASPstudio value pack: +ADw-A 
> HREF+AD0AIg-http://www.softartisans.com/aspstudiosuite.html+ACI- 
> TARGET+AD0AIgBf-blank+ACIAPg-http://www.softartisans.com/aspstudiosuite.
> html+ADw-/A+AD4APA-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4----+ADw-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4-You are currently subscribed to 
> asp+AF8-databases as: mario+AEA-tonicdesign.co.uk+ADw-/FONT+AD4-
> +ADw-BR+AD4APA-FONT SIZE+AD0-2+AD4-
> leave-asp+AF8-databases-477561D+AEA-p2p.wrox.com+ADw-/FONT+AD4-
> +ADw-/P+AD4-
>
> +ADw-/BODY+AD4-
> +ADw-/HTML+AD4-
> ------_=_NextPart_001_01C0B2D1.6107DA6C--
>
>