two tables, one with student# and name, the other with student# and parki ng#, how to find all the students that don't have parking?
Page 1 of 1
two tables, one with student# and name, the other with student# and parki ng#, how to find all the students that don't have parking?
select name
from student
where name NOT IN(
select name
from student JOIN park USING(student#)
)
from student
where name NOT IN(
select name
from student JOIN park USING(student#)
)
Similar topics
» Given a sorted array find all possible |ai - aj| where ai,aj belongs to Array A. n^2 is obvious. Find a solution in O(N).
» Find if a singly linked List has loop or not. How to find out middle element from a looped single linked list
» Design a system to manage a parking lot.
» To find the successor of x in a BST
» Find the height of BST
» Find if a singly linked List has loop or not. How to find out middle element from a looped single linked list
» Design a system to manage a parking lot.
» To find the successor of x in a BST
» Find the height of BST
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum