simple query. why series column is giving problem
I have a table equities where column names are
symbol varchar(45)
series varchar(4)
date1 Date
close_price Decimal(13,5)
My query
select * from equities where symbol like 'Tatasteel'
returns 178 rows
but some rows series is not EQ I wanted only EQ
so I changed my query
select * from equities where symbol like 'Tatasteel' and series like 'EQ'
returns 0 rows
I tried select * from equities where series = 'EQ'
even this returns 0rows
what i am doing wrong
Subject
Written By
Posted
simple query. why series column is giving problem
July 21, 2020 12:08PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.