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 |
How to create tables for odbc connection testing?
Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...
10 Answers Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,
what is difference between where clause and having clause?
How to get the Installed Oracle Version Information ?
Difference between cartesian join and cross join?
i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
what is Table ?
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
what are the advantages of running a database in archive log mode?
what is exact difference between drop and truncate table.
What is an external table?
When do you get a .pll extension in oracle?