how to Return total number of rows.
Answer / Ranjit Kumar Barnwal
To return the total number of rows in a result set, you can use the COUNT(*), which counts all rows or COUNT(column_name), which counts only non-NULL values in the specified column.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is blob datatype in mysql?
What is mysql connector used for?
What is deterministic in mysql?
How large can a mysql database become?
Is mysql a odbc?
What is strict mode in mysql?
Can you tell how to find the number of rows in a resultset using php?
What is cast in mysql?
How to get a list of all tables in a database?
What is mysql command line?
How to define numeric 9(3) in db2 table without decimal point??
Where is the myisam table stored?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)