Informatics Practices

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

SQL Queries

2 Likes

Answer

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

Answered By

3 Likes

Related Questions

Assertion (A): All aggregate functions except count(*) ignore null values in their input collection.
Reasoning (R): SUM, AVG, MIN, and MAX can only be used with numeric columns.
Both A and R are true and R is the correct explanation of A.
Both A and R are true but R is not the correct explanation of A.
A is true but R is false.
A is false but R is true.
View Answer Bookmark Now