Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / umesh h

suppose a table is there with the name tab
then count of rows in that table will be displayed.
else count of all the logical objects under one schema
will be displayed.

Is This Answer Correct ?    3 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a recursive stored procedure?

1181


What is a data manipulation language?

1024


Is it possible to create the following trigger: before or after update trigger for each row?

1286


What is the difference between Union and Union all. Which is faster.

1401


What is use of trigger?

933


how do you know the version of your mysql server? : Sql dba

1004


What is sql select statement?

1030


What are the advantages of indexing?

984


What is sql profiler in oracle?

1090


how can we find the number of rows in a table using mysql? : Sql dba

1083


How do we use distinct statement? What is its use?

1031


what is innodb? : Sql dba

1102


How do I add a primary key to a table?

1042


Which join is default?

952


Explain raise_application_error.

1092