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
- 3573 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
How is it different from a normal table?
How to login to the server without an instance?
What happens to the current transaction if the session is ended?
How to rebuild an index in oracle?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
What are the components of logical database structure in oracle database?
What is a directory object?
What is rowid and rownum in oracle?
Can group functions be used in the order by clause in oracle?
What is index in Oracle?
List the parts of a database trigger.
Are truncate and delete commands same? If so why?
Is oracle a language?
How to return top 5 rows in oracle?
How to view existing locks on the database?
