Question

select @StrName = UserId from productuser where ProductID in
((select ProductID from productassets where AssetID in(select AssetId from course where Title='Programming'))
INTERSECT
select ProductID from organizationproduct where OrganizationID in (select OrganizationID from organization where OrganizationName='Infosys'))


how to use for or while loop in sql query to get first ten values