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
- 3624 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 |
How to pass a parameter to a cursor in oracle?
What is the dynamic sql in oracle?
What are the trigger associated with image items ?
How to do paging with oracle?
What are advantages of dateset in datastage?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
Hi Can any one tell me what are the API's used in requisition import.
Write a syntax for update query in oracle?
What is connection pool in oracle?
How to create a stored program unit?
What is parameterized cursor in oracle?
Please explain compound trigger in oracle?
Oracle General 
