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

select sum(1) from table-name

Is This Answer Correct ?    26 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are keys in sql?

1040


Can we join two tables without common column?

1058


What is the difference between the sql*loader and import utilities? : aql loader

1090


What is varchar example?

1080


What will you get by the cursor attribute sql%rowcount?

1076


What sql database should I use?

1192


Define commit, rollback and savepoint?

1081


What are the different types of joins in sql?

1908


What is rank dense_rank and partition in sql?

1084


What is a field in a database?

1102


What are the types of views in sql?

1140


What is dml with example?

1154


What is record in pl sql?

1140


Can we use update in sql function?

1115


Why do we need cursors in pl sql?

1155