Needs Function - Mailing list pgsql-sql

<img class="shape" height="0" src="cid:image001.jpg@01C78CDA.5ABC5680" style="display:none;width:0;height:0"
v:shapes="_x0000_Mail"v:src="cid:image001.jpg@01C78CDA.5ABC5680" width="0" /><div class="Section1"><p class="MsoNormal"
style="margin-left:37.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy">PLEASEGO TO FOLLOWING QUERY AND REVERT TO ME IF ANY
QUERIES</span></font><pclass="MsoNormal" style="margin-left:37.5pt"><font color="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font><pclass="MsoNormal"
style="margin-left:37.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy">SELECT* FROM TEMP;</span></font><p class="MsoNormal"
style="margin-left:37.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy">DEPTNO  EMPNO</span></font><p class="MsoNormal"
style="margin-left:37.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy">------
         --------------------------------------------------</span></font><pclass="MsoNormal"
style="margin-left:37.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy">   10         B3091,B3092,B3093,B3085</span></font><p
class="MsoNormal"style="margin-left:37.5pt"><font color="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy">   11         3651,6521</span></font><p class="MsoNormal"
style="margin-left:37.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy">   12         H3062</span></font><p class="MsoNormal"
style="margin-left:37.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font><pclass="MsoNormal"
style="margin-left:75.0pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font><pclass="MsoNormal"
style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font><pclass="MsoNormal"
style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy"> 1  SELECT DEPTNO,SUBSTR(EMPNO,1,5) EMPNO FROM TEMP WHERE
DEPTNO=10</span></font><pclass="MsoNormal" style="margin-left:112.5pt"><font color="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy"> 2  UNION</span></font><p class="MsoNormal"
style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy"> 3  SELECT DEPTNO,SUBSTR(EMPNO,7,5) EMPNO FROM TEMP WHERE
DEPTNO=10</span></font><pclass="MsoNormal" style="margin-left:112.5pt"><font color="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy"> 4  UNION</span></font><p class="MsoNormal"
style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy"> 5   SELECT DEPTNO,SUBSTR(EMPNO,13,5) EMPNO FROM TEMP WHERE
DEPTNO=10</span></font><pclass="MsoNormal" style="margin-left:112.5pt"><font color="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy"> 6  UNION</span></font><p class="MsoNormal"
style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy"> 7  SELECT DEPTNO,SUBSTR(EMPNO,19,5) EMPNO FROM TEMP WHERE
DEPTNO=10</span></font><pclass="MsoNormal" style="margin-left:112.5pt"><font color="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy"> 8  UNION</span></font><p class="MsoNormal"
style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy"> 9  SELECT DEPTNO,SUBSTR(EMPNO,1,4) EMPNO FROM TEMP WHERE
DEPTNO=11</span></font><pclass="MsoNormal" style="margin-left:112.5pt"><font color="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy"> 10 UNION</span></font><p class="MsoNormal"
style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy"> 11 SELECT DEPTNO,SUBSTR(EMPNO,6,4) EMPNO FROM TEMP WHERE
DEPTNO=11</span></font><pclass="MsoNormal" style="margin-left:112.5pt"><font color="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy"> 12 UNION</span></font><p class="MsoNormal"
style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy"> 13*SELECT DEPTNO,EMPNO FROM TEMP WHERE DEPTNO=12</span></font><p
class="MsoNormal"style="margin-left:112.5pt"><font color="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy">SQL>/</span></font><p class="MsoNormal"
style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font><pclass="MsoNormal"
style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy">   DEPTNO EMPNO</span></font><p class="MsoNormal"
style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy">----------
--------------------------------------------------</span></font><pclass="MsoNormal" style="margin-left:112.5pt"><font
color="navy"face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial;color:navy">        10
B3085</span></font><pclass="MsoNormal" style="margin-left:112.5pt"><font color="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy">       10 B3091</span></font><p class="MsoNormal"
style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy">       10 B3092</span></font><p class="MsoNormal"
style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy">       10 B3093</span></font><p class="MsoNormal"
style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy">       11 3651</span></font><p class="MsoNormal"
style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy">       11 6521</span></font><p class="MsoNormal"
style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy">       12 H3062</span></font><p class="MsoNormal"
style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font><pclass="MsoNormal"
style="margin-left:112.5pt"><fontcolor="navy" face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;color:navy">7rows selected.</span></font><p><font color="#006666"
face="Arial"size="2"><span style="font-size:10.0pt; 
font-family:Arial;color:#006666"> </span></font></div><table><tr><td bgcolor="#ffffff"><font
color="#000000">Informationtransmitted by this e-mail is proprietary to Infinite Computer Solutions and / or its
Customersand is intended for use only by the individual or the entity to which it is addressed, and may contain
informationthat is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended
recipientor it appears that this mail has been forwarded to you without proper authority, you are notified that any use
ordissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately
atinfo.in@infics.com and delete this email from your records.<br /></font></td></tr></table><table><tr><td
bgcolor="#ffffff"><font
color="#000000">============================================================================================================================<br
/><br/><br /> Disclaimer:<br /><br /> This message and the information contained herein is proprietary and confidential
andsubject to the Tech Mahindra policy statement, you may review at <a
href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a>externally and <a
href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a>internally within
TechMahindra.<br /><br />
============================================================================================================================<br
/></font></td></tr></table><table><tr><tdbgcolor="#ffffff"><font color="#000000">Information transmitted by this e-mail
isproprietary to Infinite Computer Solutions and / or its Customers and is intended for use only by the individual or
theentity to which it is addressed, and may contain information that is privileged, confidential or exempt from
disclosureunder applicable law. If you are not the intended recipient or it appears that this mail has been forwarded
toyou without proper authority, you are notified that any use or dissemination of this information in any manner is
strictlyprohibited. In such cases, please notify us immediately at info.in@infics.com and delete this email from your
records.<br/></font></td></tr></table>