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 to count the no of records of a table without using
COUNT function?

Answer Posted / l meher

select max(rownum) from table_name;

Is This Answer Correct ?    24 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we commit inside a trigger?

987


Why are aggregate functions called so?

946


how to see the create table statement of an existing table? : Sql dba

1012


What is percent sign in sql?

1283


what are null values? : Sql dba

951


How do you sort in sql?

1026


What does inner join mean?

1165


What are the different types of functions in sql?

1053


How to run sql functions in pl/sql?

1052


- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1829


What are different types of keys?

1104


Can we use commit inside a trigger?

1088


Differentiate between pl/sql and sql?

1148


what are the performance and scalability characteristics of mysql? : Sql dba

996


What is program debugging?

1248