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
How many types of tables are there?
Describe different types of general function used in sql?
What is sql query limit?
What is cursor and its types?
what is the difference between cluster and non cluster index? : Sql dba
What is date functions?
Do stored procedures prevent sql injection?
Define tables and fields in a database
Can we commit in trigger?
What is sql clause?
What is the difference between join and natural join?
what tools available for managing mysql server? : Sql dba
What is normalization in a database?
Which function is used to return remainder in a division operator in sql?
Can we join same table in sql?
