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 / kart

using select command
select * from xxx; we will get the no of rows at bottom
if the feedback is unset

then use the plsql with cursor;

select rownum from table; the last value
is the number of records

Is This Answer Correct ?    4 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to write a query to show the details of a student from students table whose

952


What is the difference between alter trigger and drop trigger statements?

1050


What is sql architecture?

996


explain advantages of innodb over myisam. : Sql dba

1088


How do I add a primary key to a table?

978


How do I find duplicates in two columns?

1067


Is foreign key mandatory?

949


Explain alias in sql?

1002


How do you take the union of two tables in sql?

942


what is an index? : Sql dba

943


What is inner join in sql?

1008


Can we update views in sql?

905


What does desc stand for?

1029


what is the use of set statement in tsql? : Transact sql

956


what is unique key constraint? : Sql dba

995