0 votes 0 votes consider following relation How many number of records resulted by following SQL query? Select $T_{1}.A$ From R Where Exists (Select Count (*) From S Where R .C<S.F and S. E > 10 ); A 3 B 2 C 1 D 0 Databases made-easy-test-series + – someshawasthi asked Jan 17, 2023 edited Jan 17, 2023 by someshawasthi someshawasthi 273 views answer comment Share Follow See 1 comment See all 1 1 comment reply Godlike commented Jan 17, 2023 reply Follow Share i think you wanted to rename the R as T1, since otherwise the query is invalid since R is in FROM but selection is made on T1. anyways the count(*) always returns a tuple , even when innermost query is satisfied by none in that case count(*) gives 0 as a tuple, meaning inner query always have a result, which means the condition EXISTS always satisfies hence all tuples will satisfy the condition and be selected 0 votes 0 votes Please log in or register to add a comment.