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
1052 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 are the two different parts of the pl/sql packages?

How many clustered indexes can be created on a table?

What are sql functions? Describe the different types of sql functions?

Show how functions and procedures are called in a pl/sql block.

What is over () in sql?

What is ROWID?

Can we use commit inside a trigger?

What is the difference between pl and sql?

What is a mutating table and a constraining table?

Explain sql data types?

when a procedure /package is getting invalidated?

what are null values? : Sql dba

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)