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...

How do u count no of rows in a table?

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


Please Help Members By Posting Answers For Below Questions

What do you mean by stored procedures? How do we use it?

993


What is the purpose of primary key?

1015


How do I audit the sql sent to the server?

1001


What are sql constraints?

1172


How do we accept inputs from user during runtime?

1054


What plvcmt and plvrb does in pl/sql?

1314


Is pl sql useful?

984


Which is faster truncate or drop?

1043


How can you create an empty table from an existing table?

1073


what is a composite key ? : Sql dba

1045


What is the difference between inner join and natural join?

998


What is use of term?

1057


What do you understand by pl/sql packages?

1058


What is dba in sql? : SQL DBA

1037


what are the drivers in mysql? : Sql dba

1015