•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 426,660 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,521 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 926 | Replies: 1
 |
•
•
Join Date: Mar 2008
Location: Bangalore
Posts: 31
Reputation: 
Rep Power: 1
Solved Threads: 0
Light Poster
hi ,
M facing the problem to get first 4 rows from the table .
m using sql2000. i used count but it is showing total no of rows in a table .
please let me know the query used to display rowcount.
M facing the problem to get first 4 rows from the table .
m using sql2000. i used count but it is showing total no of rows in a table .
please let me know the query used to display rowcount.
•
•
Join Date: Aug 2005
Location: near St Louis, Missouri, USA
Posts: 11,189
Reputation: 
Rep Power: 38
Solved Threads: 931
The only way to get the exact row count of the number of rows returned by a query is to count them as they are retrieved. Before starting to retrieve rows the db server knows whether or not there are more than zero rows, but doesn't know exactly how many until they have all been retrieved.
Last edited by Ancient Dragon : Mar 15th, 2008 at 7:27 am.
I think it's about time we voted for senators with breasts. After all, we've been voting for boobs long enough. ~Clarie Sargent, Arizona senatorial candidate
Those who are too smart to engage in politics are punished by being governed by those who are dumber. ~Plato
Those who are too smart to engage in politics are punished by being governed by those who are dumber. ~Plato
|
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- memory management in wndows 2000 (Windows NT / 2000 / XP / 2003)
- search database content (PHP)
- paging in php (PHP)
- ASP vbscript recordset paging headache (ASP)
- Displaying query results dynamically in table (PHP)
- pagination and search (PHP)
- Vba Excellence Needed..... Please?? (Visual Basic 4 / 5 / 6)
- Monitoring number of smtp bytes sent through python e-mail socket (Python)
- Storing dynamic form values in Arrays for display & insert (PHP)
- JTables (Java)
Other Threads in the MySQL Forum
- Previous Thread: MySQL User Limit?
- Next Thread: help I keep getting this
