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 / prakash kumar

select max(rownum)from table_name;
this will also give number of rows in your table

Is This Answer Correct ?    9 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

1019


what is 'mysqlshow'? : Sql dba

1076


Can we insert in sql function?

1142


Differentiate between % rowtype and type record.

1397


What is number function in sql?

1018


What is the difference between execution of triggers and stored procedures?

1158


how to write date and time literals? : Sql dba

1010


Why truncate is used in sql?

1044


Which are the different character-manipulation functions in sql?

1113


If a cursor is open, how can we find in a pl/sql block?

1216


What is the function that is used to transfer a pl/sql table log to a database table?

1069


How can we implement rollback or commit statement in a trigger?

1085


what is a trigger? : Sql dba

1095


What are different clauses used in sql?

1174


What does pl sql developer do?

982