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

With out using count() function. How to the find total
number of rows in a table?

Answer Posted / ramachandran

select rownum from tablename;

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is trigger price?

922


What is the location of pre_defined_functions.

1110


Why triggers are used?

936


Which kind of parameters cannot have a default value in pl sql?

1069


what are different types of collation sensitivity? : Sql dba

1021


What is the max nvarchar size?

896


what is the difference between group by and order by in sql? : Sql dba

1049


What are the differences between implicit and explicit cursors?

1002


What is a trigger in sql?

1156


What is self-join and what is the requirement of self-join?

1088


What is left join example?

888


How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1155


Where not exists in sql?

907


how to start mysql server? : Sql dba

1141


What is the difference between rollback and rollback to statements?

1012