This content has been marked as final. Show 3 replies
is type of the column "ab" number or not?
Yes, ab datatype is in varchar but I have also changed that ab=to_char(200) but still I am getting the Invalid Number.
Kamal1 person found this helpful
It seems you missed giving object in Where condition. Please try the query in the below manner
Select a.ab from (select ab,bc,cd from abc) a where a.ab >=101 and a.ab<=200
If this is correct, please mark Correct or Helpful