HPE Community
Operating System - HP-UX
1753948 Members
7436 Online
108811 Solutions
New Discussion

SQL not equal questio

 
DnD_1
Regular Advisor

‎05-13-2009 05:52 AM

‎05-13-2009 05:52 AM

SQL not equal questio

hi guys,

tried to run this sql cmd but always got the wrong result.

select * from bank.user where uid<>'24%' and rownum<5;

or

select * from bank.user where uid!='24%' and rownum<5;

the result always show with

uid
2400
2401
2402
2403 and so on..

any advises ?
0 Kudos
Reply
1 REPLY 1
DnD_1
Regular Advisor

‎05-13-2009 06:01 AM

‎05-13-2009 06:01 AM

Re: SQL not equal questio

got the answer :)
not like it should be...
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.