HAVING clause is used when you want to specify a condition for a group function and it is written after GROUP BY clause. The WHERE clause is used when you want to specify a condition for columns, single row functions except group functions and it is written before GROUP BY clause if it is used.

Mushtaque

• Aug 25th, 2013

WHERE clause can contains condition that must be met and should directly follow the from clause. And HAVING clause can precede GROUP BY clause,but it is more logical to declared in after GROUP BY clau...

Santhoshkandula

 Profile Answers by Santhoshkandula Questions by Santhoshkandula

• May 11th, 2011

   we have to apply the condition Before grouping the records then you have to use WHERE clause.   we have to apply the condition after grouping the records then you have to apply HAVING clause.  Thanks & Regards    K.Santhosh

Answer Question  Select Best Answer

Rename is a permanent name given to a table or column whereas Alias is a temporary name given to a table or column which do not exist once the SQL statement is executed.

Asish

• Jan 7th, 2018

Rename: Renaming to a object.

Allows: Referring to a object to avoid the ambiguity on entity or attribute.

Pandurang

• Dec 15th, 2017

Rename is used to change the name of the table permanently.
Alias is the alternate name of the table

Answer Question  Select Best Answer

NULLNOT NULLCHECKDEFAULT

ASISH PATRO

• Jan 8th, 2018

Constraints are divided into two part
field level
Default
check
not null

column level

unique
primary
foreign

Amarjeet

• Jul 7th, 2017

NOT NULL

Answer Question  Select Best Answer