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 Difference between Having and Where clause?

Answer Posted / joe

When we used group by that time only we can use having. But without group by we can use having.
Only grouped column have used in having condition

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is normalisation and its types?

1042


Can we create clustered index without primary key?

997


what are the differences between char and nchar? : Sql dba

1157


Can you call pl/sql package functions from within a fast formula?

1080


what are the advantages of mysql in comparison to oracle? : Sql dba

1044


How do you know if a relationship is 2nf?

991


ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2549


Is full outer join same as cross join?

1013


What is trigger in pl sql?

1045


What is not in sql?

997


The select into statement is most often used to create backup copies of tables or for archiving records?

1115


Write a sql query to get the third highest salary of an employee from employee_table?

1116


What is a string data type in sql?

1099


What is the usage of the distinct keyword?

1271


What is cartesian join in sql?

1188