Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • Last Modified:

Operator '<=' facing multi-value data

I have the following code:

select * from Request_History
where
      Stage_No <= (select Stage_No from Work_Flow where Role_ID='7')

The question is: this (select Stage_No from Work_Flow where Role_ID='7') sometimes return more than one value, then what operator other than the '<=' shall I use in this case?
0
alfardan
Asked:
alfardan
2 Solutions
 
Jim P.Commented:
Try this:
select * 
from Request_History
where Stage_No IN (select Stage_No 
                   from Work_Flow 
                   where Role_ID='7')

Open in new window

0
 
Terry WoodsIT GuruCommented:
Or one of these, depending on the result you want when there's more than one row returned by the subquery:
select * from Request_History
where Stage_No <= (select min(Stage_No) from Work_Flow where Role_ID='7')
 
select * from Request_History
where Stage_No <= (select max(Stage_No) from Work_Flow where Role_ID='7')

Open in new window

0
 
lwadwellCommented:
Hi alfardan,

perhaps you should do

lwadwell
select * from Request_History
where
      Stage_No <= (select max(Stage_No) from Work_Flow where Role_ID='7')

Open in new window

0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now