convert hr to minutes and add mm part to converted minutes

hi
i am using oracle 8i
my table structure is
SQL> desc TESTEFFORT
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ------------
--------------------
 NO                                                             NUMBER(4)
 HOURS                                                          NUMBER(5,2)

SQL> select * from TESTEFFORT;

       NO     HOURS
--------- ---------
        1       1.5
        1       1.5
        1       .35
        1      1.05
        1       2.4
        2       1.5
        2       1.5
        2       1.5
        2       1.5
        2       1.5
i want  individual  sum of minutes  
the out put is
No          minutes
-----------------
1          380
2          550
schavalamAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
RimvisConnect With a Mentor Commented:
Is this what you want:

select No, SUM(HOURS) * 60 AS minutes from TESTEFFORT GROUP BY No;
0
 
gajender_99Commented:
select No, SUM(HOURS) * 60 AS minutes
from TESTEFFORT
GROUP BY No
order by no asc;

0
All Courses

From novice to tech pro — start learning today.