Interested to Buy Any Domain ? << Click Here >> for more details...
difference between group clause and order clause
- 1 Answers
- 5209 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is the purpose of rollback and commit?
How to define the a field which accepts value till 99999.99 in db2
Highlight all the advantages that are attached to a package.
what's the error code for Unique Index Violation?
What is db2 isolation?
What is the difference between dbm cfg and db cfg file in db2 ?
What is cascading rollback?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?
Are views updatable ?
Mention the various locks that are available in db2.
What are the levels of isolation available with DB2V4
COBOL 
