Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between group by and order by?
- 2 Answers
- 14634 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sunil1405
Group By controls the presentation of rows , order by
controls the presentation of columns.
| Is This Answer Correct ? | 15 Yes | 7 No |
Answer / visakh viswanath
Difference between order by and group by having ?
suppose i have students table which has id number ,sname
varchar2(20),marks1number ,marks2 number,marks3 number,age
number.
i would like to illustrate what i understood
suppose i want to select students whose id > 2000 and age
>30
my query would be like this
select * from students where id >2000 and age >30 order by
age desc ;
or
else
select * from students group by age ,id having age >30 and
id >2000 ;
so both the queries would be same but in the first one i
use order by followed by my condition in where .
in second once i used group by which would group according
to the age or id and then having is same as where condition
in the above .
| Is This Answer Correct ? | 3 Yes | 7 No |
What is ibm db2 used for?
What types of tables are there in the db2 database?
How do you prepare a COBOL + DB2 program from coading till execution ?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country
How do you pull up a query which was previously saved in qmf?
What is null value in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
If I have a view which is a join of two or more tables, can this view be updateable?
What is a LIKE table and how is it created?
wht is d/f between union and joins ?
What is PRIME TABLE and what are the uses of it
COBOL 
