what is Difference between Having and Where clause?

Answer Posted / tanmoy

We can use arithmetic operator in having clause but it is
not possible for where clause..

Is This Answer Correct ?    0 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql exception?

705


What is cartesian join in sql?

742


When to use inner join and left join?

694


What are analytic functions in sql?

742


What is the command used to fetch the first 5 characters of a string?

922






Does sql*plus have a pl/sql engine?

753


Does varchar need length?

711


what is sp_pkeys? : Transact sql

889


Why do we use cursors?

668


What programs use sql?

728


What is trigger types of trigger?

718


difference between anonymous blocks and sub-programs.

818


What are all the different normalization?

744


Is there a 64 bit version of ssms?

678


How many tables can you join in sql?

706