Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / bolearner
There are 2 ways used to find the row count of any table.
SELECT COUNT(*) FROM EMP;
SELECT TABLE_NAME, NUM_ROWS FROM USER_TABLES WHERE TABLE_NAME='EMP';
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is native sql query?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
Why do we use joins?
How to add a column ‘salary’ to a table employee_details?
What is count * in sql?
What is the difference among union, minus and intersect?
how to shutdown mysql server? : Sql dba
what is the difference between char_length and length? : Sql dba
What is the use of <> sql?
What is output spooling in sql*plus?
What is set serveroutput on?
Why do we use partitions in sql?
Can we join tables without foreign key?
What is t sql used for?
What is rownum in sql?
