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

Answer Posted / shivashanker

it will display the total number of tables in the schema.

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of functions in sql?

523


Can we use joins in subquery?

545


What does dml mean?

562


what are the different type of normalization? : Sql dba

560


What is primary key and foreign key with example?

504






What does over partition by mean in sql?

543


Is it possible to sort a column using a column alias?

615


How to return an array from java to pl/sql?

603


How many types of sql are there?

537


What does the sign mean in sql?

521


What is data control language?

539


how mysql optimizes distinct? : Sql dba

561


Enlist the advantages of sql.

583


What is recursive join in sql?

556


how to create a new table by selecting rows from another table in mysql? : Sql dba

572