asked on
How can I get multiple results with the where clause. In Oracle SQL
In Oracle SQL how could I do create this Query. I would like to check for multiple conditions with the where clause.
select * from lawprod.WHSHIPLINE where company=10 location=98MDC update-date='01/20/2018'
It works if I do this
select * from lawprod.WHSHIPLINE where company=10
However, I would like to check for more conditions like
I would like to include data of the company=10 and location=98MDC and update_date = 01/20/2018
Thanks for any help!
select * from lawprod.WHSHIPLINE where company=10 location=98MDC update-date='01/20/2018'
It works if I do this
select * from lawprod.WHSHIPLINE where company=10
However, I would like to check for more conditions like
I would like to include data of the company=10 and location=98MDC and update_date = 01/20/2018
Thanks for any help!
Oracle DatabaseSQL
Last Comment
slightwv (䄆 Netminder)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
There are 4 parens in his solution. Make sure you copy/paste them all. If possible, use a visual editor that matches parens and highlights syntax.
ASKER
Thank you!
Are you trying to AND or OR the conditions together?
I'm late to the party but I'm not sure they need the inner select and hitting the table twice:
SELECT *
FROM lawprod.whshipline
WHERE company = 10 AND location = '98MDC' AND update_date = To_date('01/20/2018', 'mm/dd/yyyy'))
;
slightwv, I read the requirement differently and the inner select would be needed. I read it as you want all of company 10 if the other conditions are met by at least one record. Not sure you can do that without the inner select and yours seems to only give the records that satisfy all 3 conditions. Not all the records that satisfy the first condition if there is one record that satisfies all 3.
>>I read it as you want all of company 10 if the other conditions are met by at least one record.
I can see it that way.
I can see it that way.
ORA-00907: missing right parenthesis
00907. 00000 - "missing right parenthesis"
*Cause:
*Action:
Error at Line: 11 Column: 48