Interested to Buy Any Domain ? << Click Here >> for more details...
consider some table with 4 r 5 columns in that 1 col is
DATE type. The data is like that,For each date in that col
some 3 fields r there but all the records r having
different data. Now i want to display all the columns by
performing grouping on the date field ( as SELECTION
Operator(*) cannot be used with group function having only
one "group by clause". how to do this? can any one help me
in finding out the solution plss?
- 1 Answers
- 3548 Views
- I also Faced
- E-Mail Answers
Answer / mukti singh
First of all you need to understand that purpose of
grouping.
Group by is used when you need to club a few columns on the
basis of one column, for this you need to use some
aggregate functions,
for eg. for a table test
a b c
1 2 29-JUN-08
1 4 29-JUN-08
3 5 04-JUL-08
13 15 05-JUL-08
you can group a and b on c as follows:-
select count(a), max(b), c from test
group by c
count(a)max(b) c
2 4 29-JUN-08
1 5 04-JUL-08
1 15 05-JUL-08
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a SNAPSHOT ?
What is sharded cluster?
select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help
What is COST-based approach to optimization ?
How to select the name of employee who is getting maximum sal with out using subquery
What is an anonymous block?
How does one get the view definition of fixed views/tables?
How to set up autotrace for a user account?
How do we get field detail of a table?
What is define in oracle?
what is the difference between sql& oracle?
How to upsert (update or insert into a table)?
Oracle General 
