Answer / chandrakala

Having clause is used for filtering grouped data and where
clause is used for filtering rows.

Answer / ganesh

where clause check a condition & having clause is use in
group by clause

Answer / nrapendra

where clause filter the data before gruop by clause and
having clause clause filter the data after group by clause

Answer / 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

Answer / tanmoy

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

What are triggers and its types?

0 Answers  

Main diff between varray and nested tablea

3 Answers   Polaris, TCS,

Is it possible for a table to have more than one foreign key?

0 Answers  

What are the disadvantages of file system?

0 Answers  

i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks i need 1st dd for evry wk

1 Answers   Aspire,

Is sql a backend?

0 Answers  

Does sql full backup truncate logs?

0 Answers  

What is intersect?

1 Answers  

Why is stored procedure faster than query?

0 Answers  

What is the difference between joins?

0 Answers  

Is it possible to include an insert statement on the same table to which the trigger is assigned?

0 Answers  

if we give update table_name set column_name= default. what will happen?

4 Answers   iFlex,