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
- 3623 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 to load a large xml file?
Explain the difference between a procedure and a function? What do you understand by those terms?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
why dont we assign not null constraint as table level constraint.
What is the data type of dual table?
How to initialize variables with default values?
Explain mutating triggers.
How to assign a tablespace to a users in oracle?
How to use group functions in the select clause using oracle?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How can I combine multiple rows into a comma-delimited list in oracle?
What do you mean by redo log file mirroring?
What are the tools for Oracle ?
What are the roles of dba?
