316 views
1 votes
1 votes

consider the following table 

A B
1 NULL
2 1
3 2
4 2

SELECT * FROM R AS R1 WHERE NOT EXISTS (SELECT * FROM R WHERE B=R1.A);

NO OF TUPLE RETURNED BY THE QUERY IS -------------------------

1 Answer

Related questions

0 votes
0 votes
1 answer
3
rayhanrjt asked Jan 6, 2023
720 views
Write SQL command to find DepartmentID, EmployeeName from Employee table whose average salary is above 20000.
2 votes
2 votes
1 answer
4
Subhrangsu asked Jun 18, 2022
432 views
Write SQL query to show all employees hired on June 4,1984 (non-default format)emp(empno,ename,job,mgr,hiredate,sal,comm,deptno)