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
2 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.
ABC Associates has over 2000 employees on its roll and deals with customer support services. Help the company to perform associated operations for calculating the salaries (stored in Sal column) of their employees and to perform relevant analysis on the fetched data from the SQL database/table.
How can we retrieve records where salary is between 1000 and 2000?
If there are two tables emp and emp1, and both have common records, how can we fetch all the records but common records only once?
How can we fetch only common records from two tables emp and emp1?