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
- 3549 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between PFILE and SPFILE in Oracle?
Difference between open_form and call_form in oracle.
What is an oracle?
What are the components of logical database structure in oracle database?
What is procedure overloading in oracle?
What do you know about normalization? Explain in detail?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
What is an oracle transaction?
What is data type in oracle?
What is a snapshot in oracle database?
What is dynamic proxy?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
How to end the current transaction in oracle?
How to rebuild an index in oracle?
what is a Nested Loop join?
