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 / sudhakar & co

select rownum from table_name;

Is This Answer Correct ?    1 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you sum a count in sql?

1061


How many sql core licenses do I need?

995


How do you explain an index?

1331


What does the argument [or replace] do?

1128


What does pl sql developer do?

982


What is a function in oracle pl sql?

1098


Explain how can you save or place your msg in a table?

1076


What is where clause in sql?

1087


what is a database transaction? : Sql dba

1258


i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1631


Are pl sql variables case sensitive?

1092


Explain the types of joins in sql?

1073


How can the performance of a trigger be improved?

1088


In a distributed database system, can we execute two queries simultaneously?

1155


Is ms sql is free?

1082