hi - Mailing list pgsql-sql
| From | Penchalaiah P. |
|---|---|
| Subject | hi |
| Date | |
| Msg-id | A70AE049E81A6A40879D5DC0AC8C38C908CD9133@venus.infics.com Whole thread Raw |
| Responses |
Re: hi
("Wilkinson, Jim" <Jim.Wilkinson@cra-arc.gc.ca>)
Re: hi ("David Flegl" <ml_flegl@centrum.cz>) Re: hi (Ragnar <gnari@hive.is>) Re: hi (Stephan Szabo <sszabo@megazone.bigpanda.com>) Re: hi (John Summerfield <postgres@herakles.homelinux.org>) |
| List | pgsql-sql |
<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>