What does “select count(*) from tab” result?

Answer Posted / amit kumar jaswal

display count of all rows from relation

Is This Answer Correct ?    3 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mutating error in pl sql?

553


what is the difference between nested subquery and correlated subquery?

554


How do you rank data in sql?

518


Can we rename a column in the output of sql query?

545


How to select random rows from a table?

529






What is difference between my sql and sql?

532


What is the most important ddl statements in sql are?

523


how to decrement dates by 1 in mysql? : Sql dba

586


What is difference between stored procedure and trigger?

539


How do I count records in sql?

520


What does the base_object_type column shows in the user.triggers data dictionary view?

578


What makes a good primary key?

528


What is the difference between sql and isql*plus?

517


What is character functions?

558


What is sql and explain its components?

604