Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

is that standard though?

by cebrown (Pilgrim)
on Apr 30, 2002 at 14:04 UTC ( #163064=note: print w/ replies, xml ) Need Help??


in reply to Re: Re: The fine art of database programming
in thread The fine art of database programming

I believe that LIMIT is a DBMS-specific extension. For example...
in MS SQL Server:

SELECT TOP 10 col FROM table
in IBM DB2:
SELECT col FROM table FETCH FIRST 10 ROWS ONLY
I think the only platform independent way to do this is:
SELECT col FROM table A WHERE 10 > (SELECT COUNT(*) FROM table B WHERE A.col < B.col) ORDER BY col DESC


Comment on is that standard though?
Select or Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://163064]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (7)
As of 2014-12-21 02:44 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (101 votes), past polls