Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sathy
group by clause is used to group the column values using
corresponding column values
group by cannot use where condition, instead of where it can
use having which has same function as where
order by is used to order the records in order ie.,
ascending or descending.
order by can use where, but not having having is only for
group by.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is db2 bind?
What r the comman abends in db2, jcl and cobol???????
Is db2 a database?
Discuss about db2 bind?
B37 abend during spufi?
What is the physical storage length of timestamp data type?
Is db2 a mainframe?
What is the maximum length of sqlca?
How do I add a column in db2?
What is reorg?
What are union and union all?
what is db2 restart?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is a db2 tablespace?
What is load utility in db2?
