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
- 3674 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 is a trigger oracle?
I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.
5 Answers Microsoft, Oracle, TCS,
Differentiate between post-database commit and post-form commit?
How to compare dates in oracle sql?
How to define an external table with a text file?
What are the general rules on data consistency?
What is cursor
Explain what does a control file contain?
What do you mean by a database transaction & what all tcl statements are available in oracle?
How to find the duplicate rows count from employees table in oracle?
What does COMMIT do ?
how to get count of tables in particular database in Oracle?
Oracle General 
