How do u count no of rows in a table?
Answers were Sorted based on User's Feedback
Answer / gunturajesh
select count(*) from table will give the number of rows in
the table including null values
Is This Answer Correct ? | 32 Yes | 3 No |
Answer / bj
select count(1) from <table_name>;
By this also we can count no of rows in a table.
Is This Answer Correct ? | 19 Yes | 2 No |
Answer / prakash kumar
select max(rownum)from table_name;
this will also give number of rows in your table
Is This Answer Correct ? | 9 Yes | 3 No |
Answer / prabhudatta barick
Please ignore my first answer...
as By default this job runs within a maintenance windows
between 10 P.M. to 6 A.M. week nights and all day on
weekends.
to get the exact record please use this
ANALYZE TABLE <table_name> COMPUTE STATISTICS;
SELECT num_rows
FROM dba_tables
WHERE table_name = '<TABLE_NAME>';
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / prabhudatta barick
Automatic Optimizer Statistics Collection
By default Oracle 10g automatically gathers optimizer
statistics using a scheduled job called GATHER_STATS_JOB.
As it gathers table statistics automatically
so no need to gather table statistics before
running this query.
SELECT num_rows
FROM dba_tables
WHERE table_name = '<TABLE_NAME>';
This will give u the total no. of records in a table....
Is This Answer Correct ? | 1 Yes | 0 No |
What is a subquery in sql?
a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.
what are the 'mysql' command line options? : Sql dba
What language is oracle sql developer?
What are records give examples?
Do prepared statements prevent sql injection?
What is dml statement?
Can procedure in package be overloaded?
how to drop an existing table in mysql? : Sql dba
What is record type in pl sql?
What is cost in sql execution plan?
What is the maximum number of rows in sql table?