What is the difference between count 1 and count (*) in a sql query?

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

What is the difference between count 1 and count (*) in a sql query?

Question Posted / arjun

0 Answers
1050 Views
I also Faced
E-Mail Answers

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

what is data integrity? : Sql dba

Which is better varchar or nvarchar?

How does postgresql compare to "nosql"?

what is sql in mysql? : Sql dba

what are the different type of normalization? : Sql dba

What is the benefit of foreign key?

What is the use of triggers?

What is dml and ddl?

Is sql database free?

how to return query output in html format? : Sql dba

how is exception handling handled in mysql? : Sql dba

What is pl/sql table? Why is it used?

For more SQL PLSQL Interview Questions Click Here

Categories

Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)