Hi Sapient(Bangalore) is looking for people with 2.5+ years of Exp in Java domain(See the mail below). If you or any of your friends are interested, send the...
This is a one-time mail by ACM. Please join acm-bangalore-chapter@googlegroups.com to get more invites to talks/meeting/updates related to Computer Science and...
Hi, I created simple application ConvertCurrency given in apple tutorial. Now in one of the class i need NSWindow object reference. So how to get that one. I ...
Hi All The World's toughest problems are IT related? Try selling that to the Jarawas (http://tourism.andaman.nic.in/tribal.htm#JARAWAS ) Anyways Microsoft...
Is anybody working in KPIT Cummins ? ... Everyone is raving about the all-new Yahoo! Mail beta. [Non-text portions of this message have been removed]...
Hi I have a application which made in VB6.0 and back-end SQL-server, my problem is this when my server restarts then query running speed is good but after some...
Hi all Sapient(Bangalore) is looking for people with 2+ years of Exp in Java domain(See the mail below). If you or any of your friends are interested, send...
Hi Sapient(Bangalore/Gurgaon) is looking for people with 2+ years of Exp in Java/J2EE domain(See the mail below). If you or any of your friends are interested,...
Hi ECFY is looking for people at its Baroda Development Center. ECFY is a specialist company in logistics solutions and has its own products in areas of...
Hi All, Currently at Accenture, we have a number of openings in various skills and at various levels. Major skills where we have requirements are: 1. Java...
Hi, Can anybody help me in finding 2nd or 5th or say n'th largest value?If i have a employee table and i want to find 2nd highest salary from the table what...
Prashant Kulkarni
mailprashant_kulkarni...
Mar 8, 2007 6:46 am
9958
Hi Prashant, Use Rank() or Dense_Rank() analytics function. Example, select emp_name, sal, rank() over (order by sal) rank from employee order by rank Thanks...
alternatively you can do something like below. select rowcount,empid,sal from ( select empid, sal from emp order by sal desc; ) where rowcount=N; i havent...
Another way of doing it @ http://orafaq.com/scripts/sql/maxvalue.txt Interestingly, with quite similar example. -- select level, max(sal) from emp -- where...
Prashant, If you are using Oracle, I would suggest: select rnum, col1 from (select rownum, col1 from table1 ) where rnum=2 or rnum=5 / Since 'rownum'...
Prashant, If you are using Oracle, I would suggest: select rnum, col1 from (select rownum, col1 from table1 ) where rnum=2 or rnum=5 / Since 'rownum'...
Prashant, If you are using Oracle, I would suggest: select rnum, col1 from (select rownum, col1 from table1 ) where rnum=2 or rnum=5 / Since 'rownum'...
oh i forgot its rownum and not rowcount ..... its been really long since i last touched oracle :) btw you forgot to sort it out ;) nonetheless i guess...
Hi All, we have one open position for the following skillset. CVs to be FWDed to my personal ID : ameyas7 [at] yahoo [dot] com DO NOT REPLY TO THE GROUP Job...
Hi all, My brother got an offer from Aurora Worldwide for a profile of *F**inancial Engineering *at following location. *Aurora Solutions, Inc.* 1350 Remington...
This has really helped me a lot thanks Avinash,Amey,Amber,Suhas. amey samant <ameyas7@...> wrote: oh i forgot its rownum and not rowcount ........
Prashant Kulkarni
mailprashant_kulkarni...
Mar 9, 2007 12:37 pm
9968
Hi, I have attached my resume with this mail. Thanks & regards, Sarika Kartik Shah <kartik.group@...> wrote: Hi All, Currently at Accenture, we have a...
Hi Sapient(Bangalore/Gurgaon) is looking for people with 2.6+ years of Exp in Java/J2EE domain(See the mail below). If you or any of your friends are...
Hi Guys & Gals, Is any one of you working in Xansa India Ltd Chennai? Or do you have friend working with Xansa? One of my friend wants to join the company and...
Hi, I need to get some information contained in the IEEE 802.11n WLAN draft. My company might be purchasing a copy of the standard soon, but that might take a...
Hello, In Stored Procedures of MS SQL, I am building up a query and storing it in a variable. Have set the data type of the variable to be NVARCHAR, since I...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
