Interested to Buy Any Domain ? << Click Here >> for more details...
difference between group clause and order clause
- 1 Answers
- 5146 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 |
How do you Load a table ?? and what is Load replace ?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
what's the best lock size that you could use when you create a tablespace?
Describe what a storage group(STOGROUP) is?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
What is cursor stability in db2?
What is declare cursor?
What is ibm db2 database?
Can I use LOCK TABLE on a view?
What is the use of commit in db2?
COBOL 
