cancel
Showing results for 
Search instead for 
Did you mean: 

SQL not equal questio

DnD_1
Regular Advisor

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 ?
1 REPLY
DnD_1
Regular Advisor

Re: SQL not equal questio

got the answer :)
not like it should be...