Interested to Buy Any Domain ? << Click Here >> for more details...
difference between group clause and order clause
- 1 Answers
- 5141 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 |
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
On which levels locks can be applied?
What information is used as input to the bind process?
What are catalog tables in db2?
How can record locking be achieved in those DB2 versions which do not support it?
Comment whether the cursor is closed during commit or not.
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How does DB2 use multiple table indexes?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
COBOL 
