You can query only one table with multiple IDs.

Multiple ID ing tables query only one table, for example, company Table ----- employee info table www.2cto. comORGID -- USERIDUSERID--USERINFO relationship one-to-many... to query each company, only one employee number is displayed: SELECT * FROM (SELECTA. *, ROW_NUMBER () OVER (PARTITIONBYorgidORDERBYA. USERID) RNFROMus

Multiple ID ing tables only query one if company Table ----- employee info table www.2cto.com ORGID -- USERID USERID--USERINFO relationship one to multiple... to query each company, only one employee ID is displayed: SELECT * FROM (select. *, ROW_NUMBER () OVER (partition by orgid order by. USERID) rn from us

You can query only one table with multiple IDs.

Assume that the company Table ----- employee information table

Www.2cto.com

ORGID -- USERID USERID--USERINFO

Link One to multiple...

To query each company, only one employee ID is displayed.

SELECT * FROM

(

Select a. *, ROW_NUMBER () OVER (partition by orgid order by a. USERID) RN

FROM usr

)

Where rn = 1