Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 10 of 79

Database Query using SQL — Question 2

Back to all questions
2
Question

Question 2

Select all records where dept no of both emp and dept table matches.

Answer 
SELECT * 
FROM emp e, dept d 
WHERE e.deptno = d.deptno;