SQL Query to get multiple records

Hi Madan

I got the expected result with the below query using cross join

SELECT R.RouteID, tblRights.item as RGHT_ID FROM Onesite.Route R, OneSite.udfSplitPattern('1405,23.999', ',') tblRights

WHERE RouteURI IN

(

'/api/ledger/payment/paymentInfo'

)

0

Rakesh reddy7y ago

My scenario is different Madan,

For matching RouteURI i need the result in three times with the different rightid.

0

Madan Shekar7y ago

i guess like you have to pass value

rightId = ('1405','23','999')

then only u will get 3 records

0

Madan Shekar7y ago

example
tbl columns

id name

1 madan

2 kiran

3 sharan

4 john

query

select * from tblname where id in ('1','2','4')

result is
1 madan

2 kiran

4 john

-1

Rakesh reddy7y ago

Hi Madan

My table Route is having only two columns

column1 : RouteID

Column2 : RouteURI

0

Madan Shekar7y ago

using in only you can do...
pls drop your tbl clomns with sample data

+1