hi

<div class="Section1"><p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><font
color="black"face="Times New Roman" size="3"><span style="font-size:12.0pt; 
color:black">Hi </span></font><p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><font
color="black"face="Times New Roman" size="3"><span style="font-size:12.0pt; 
color:black">I have the data like this in <b><span style="font-weight:bold">temp</span></b> table</span></font><p
class="MsoNormal"style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><font color="black" face="Times New Roman"
size="3"><spanstyle="font-size:12.0pt; 
color:black">SQL> Select sno, value from temp;</span></font><p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><fontcolor="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;
color:black;font-weight:bold">SNO                           Value</span></font></b><p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:75.0pt"><font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">1                    650.00</span></font><p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:75.0pt"><font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">2                    850.00</span></font><p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:75.0pt"><font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">3                    640.00</span></font><p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:75.0pt"><font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">3                    985.00</span></font><p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:75.0pt"><font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">5                    987.00</span></font><p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:75.0pt"><font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">9                    9864.00</span></font><p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:75.0pt"><font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">7                    875.00</span></font><p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><fontcolor="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;
color:black">Now, I want display the result like this…</span></font><p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><fontcolor="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;
color:black">SQL> Select sno, value, </span></font><font color="red"><span
style="color:red">get_sum(value)</span></font><fontcolor="black"><span style="color:black"> as sum from
temp;</span></font><pclass="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><font
color="black"face="Times New Roman" size="3"><span style="font-size:12.0pt; 
color:black;font-weight:bold">        SNO                   Value              SUM</span></font></b><p
class="MsoNormal"style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; 
margin-left:75.0pt"><font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">1                    650.00             650.00</span></font><p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:75.0pt"><font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">2                    850.00             1500.00          
--650+850</span></font><pclass="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; 
margin-left:75.0pt"><font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">3                    640.00             2140.00          
--1500+640</span></font><pclass="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; 
margin-left:75.0pt"><font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">3                    985.00             3125.00           --
2140+985</span></font><pclass="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto; 
margin-left:75.0pt"><font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">5                    987.00             4112.00</span></font><p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:75.0pt"><font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">9                    9864.00           13976.00</span></font><p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:75.0pt"><font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">7                    875.00             14851.00</span></font><p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:75.0pt"><font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black"> </span></font><pclass="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:75.0pt"><font color="black" face="Times New Roman" size="3"><span style="font-size:12.0pt;color:black">Any
onecan tell me query for this .. I don’t want any procedure or function…</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><strong><b><font face="Monotype Corsiva" size="3"><span
style="font-size:12.0pt;font-family:"MonotypeCorsiva"">Thanks & Regards</span></font></b></strong><p
class="MsoNormal"><strong><b><fontface="Monotype Corsiva" size="3"><span style="font-size:12.0pt;font-family:"Monotype
Corsiva"">PenchalReddy</span></font></b></strong><p class="MsoNormal"><font face="Times New Roman" size="3"><span
style="font-size:
12.0pt"> </span></font></div><table><tr><td bgcolor="#ffffff"><font color="#000000">Information transmitted by this
e-mailis proprietary to Infinite Computer Solutions and / or its Customers and is intended for use only by the
individualor the entity to which it is addressed, and may contain information that is privileged, confidential or
exemptfrom disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been
forwardedto you without proper authority, you are notified that any use or dissemination of this information in any
manneris strictly prohibited. In such cases, please notify us immediately at info.in@infics.com and delete this email
fromyour records.<br /></font></td></tr></table>