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
- 3571 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 are the data types in oracle?
What is a Database instance ? Explain?
What is an oracle table?
What is forall Statement ?
What are the differences between a sys and system user and what are the extra privileges available to the sys user?
How many types of database triggers exist?
What are a cluster and non-cluster index?
Which environment variables are absolutely critical in order to run the OUI?
What are the tools for Oracle ?
How to define an oracle sub procedure?
What is oracle server autotrace in oracle?
what is Table ?
Oracle General 
