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

Answer Posted / vijay

it will result number of records in a table

Is This Answer Correct ?    3 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How are sql commands classified?

794


what are local and global variables and their differences? : Sql dba

706


tell me about various levels of constraint. : Sql dba

744


What is the difference between having and a where in sql?

793


what are the types of subquery? : Sql dba

763






What is pivot in sql?

662


What are tables in sql?

734


what is bcp? When is it used?

762


Is natural join same as inner join?

669


What are primary key and foreign key and how they work?

739


How do I view a table in sql?

714


What is the best sql course?

708


how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

830


Is sql port 1433 encrypted?

774


How to display the current date in sql?

766