Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
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...