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?
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 |
Explain a synonym?
Explain cascading triggers.
Difference between oracle's plus (+) notation and ansi join notation?
Oracle
0 Answers ABC, Genpact, HUI, Oracle,
How to create a temporary table in oracle?
What is a static data dictionary in oracle?
Difference between cartesian join and cross join?
Why cursor variables are easier to use than cursors?
What is the difference between RBBMS & DBMS?
What is max rowid in oracle?
How to insert a new row into a table in oracle?
How many types of segments in Oracle?