SQL - Interview Questions for beginners - LIK LearninKannada

Hello All ! Welcome to learninKannada Youtube channel.
Please support by Like, share and subscribe
ಎಲ್ಲೆರಿಗು ನಮಸ್ತೆ
ಕನ್ನಡದಲ್ಲಿSQL ಕಲಿಯಲು LearninKannada ವಾಹಿನಿಗೇ ಚಂದಾದಾರರಾಗಿ

ORACLE SQL INTERVIEW QUESTIONS FOR BEGINNERS

SELECT * FROM employees;
1. Write an SQL query to find the second highest salary from a table;
select MAX(salary) FROM employees WHERE salary (
SELECT MAX(salary) FROM employees);
NOTE: less than symbol removed due to constraints in youtube description

2. How would you find the employees who do not have managers in the "employees" table?;
SELECT * FROM employees WHERE manager_id IS null;

3. Write an SQL query to display the number of employees in each department;
SELECT department_id,COUNT(employee_id) as employee_count FROM employees GROUP BY department_id;

4. How would you update a record in SQL?
UPDATE employees
SET department_id=80
WHERE employee_id=178;
commit;

SELECT * FROM employees where employee_id=178;

Видео SQL - Interview Questions for beginners - LIK LearninKannada канала LIK learninkannada