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 does “select count(*) from tab” result?

Answer Posted / brajesh kr.

select count(1) from table. will return values without null
values. count(*) will return values aceept null also.

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain correlated query work?

1054


Write the alter statement to enable all the triggers on the t.students table.

1125


Why should I use postgresql?

1014


what are set operators in sql? : Sql dba

1052


Why we use triggers in mysql?

992


How can get second highest salary in sql?

988


Can procedure in package be overloaded?

1085


What are different types of triggers?

1110


Are dml statements autocommit?

1045


Mention what are different methods to trace the pl/sql code?

1205


When is a declare statement required?

1138


What operators deal with null?

1107


What is a table partition?

1131


What is pivot query?

1070


What are sql constraints?

1174