<body><script type="text/javascript"> function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener('load', function(){ object[attribute] = val; }, false); } else { window.attachEvent('onload', function(){ object[attribute] = val; }); } } </script> <div id="navbar-iframe-container"></div> <script type="text/javascript" src="https://apis.google.com/js/platform.js"></script> <script type="text/javascript"> gapi.load("gapi.iframes:gapi.iframes.style.bubble", function() { if (gapi.iframes && gapi.iframes.getContext) { gapi.iframes.getContext().openChild({ url: 'https://www.blogger.com/navbar/15383080?origin\x3dhttp://itpapersguru.blogspot.com', where: document.getElementById("navbar-iframe-container"), id: "navbar-iframe" }); } }); </script>

Wednesday, November 29, 2006

Finding duplicate rows in a table

3> select cargo_id, dest_id
4> from routing t1
5> where
6> ( select count(*)
7> from routing t2
8> where t2.dest_id = t1.dest_id ) > 1
9>
10> go

Monday, November 13, 2006

FREE: SCBCD 5.0 Beta Certification Exam

All JAVA Savvy ….

Sun is organizing FREE Certification program.

----------------------------------------------------
FREE: SCBCD 5.0 Beta Certification Exam
----------------------------------------------------

This will save at least Rs.7200 from your account.
So just Check out the following link for more information.
http://www.sun.com/training/certification/java/beta_scbcd.xml

Wish you All the Best...!