Informatics Practices
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?
Related Questions
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?
Select all records where dept no of both emp and dept table matches.
How can we fetch only common records from two tables emp and emp1?
How can we retrieve all records of emp that are not present in emp1?