Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re: Querying Select Number of Rows

by one4k4 (Hermit)
on Jun 05, 2001 at 20:34 UTC ( [id://85871]=note: print w/replies, xml ) Need Help??


in reply to Querying Select Number of Rows

set rowcount 11 select first_name from database where start_date <= '2001/04/14' and stop_date > '2999/12/31'

Something similar to that concept in your sql may help.... rowcount works with Sybase. MySQL, I dont know.

Update:I took the talk about his posted code out, and realized it just didnt fit in this thread. Regardless, the rowcount idea, kind of follows the suggesstion(s) above.

_14k4 - webmaster@poorheart.com (www.poorheart.com)

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others sharing their wisdom with the Monastery: (3)
As of 2025-06-18 03:01 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?
    erzuuliAnonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.