Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Thierry888
-
Retunring total number of records from query
Thanx for the answers guys ! First answer : count(*) does not give me the right result, since the query is much more complex with a lot of where clauses. If you mix count(*) with normal fields on the select line, you are obliged to use the GROUP BY which act as an input for count(*). I tried...- Thierry888
- Post #4
- Forum: ANSI_SQL
-
Retunring total number of records from query
I am a newbie on forums, please forgive me any mistakes... I'm trying to page through the data of a query. I already know to first use ORDER BY to order the returned records. I found how to use LIMIT x,y to get a specific part of the total query in the result set. So far, so good... And here...- Thierry888
- Thread
- Replies: 3
- Forum: ANSI_SQL
