sql nested select
SELECT * FROM students WHERE notes > ( SELECT AVG(notes) FROM students );
SELECT * FROM students WHERE class_id = (
SELECT id FROM classes WHERE number_of_students = (
SELECT MAX(number_of_students) FROM classes
)
);
SELECT subject, MAX(salary_by_subject.avg_salary) AS max_salary
FROM (
SELECT subject, AVG(monthly_salary) AS avg_salary
FROM teachers
GROUP BY subject
) salary_by_subject;select in select sql
SELECT column1 = (SELECT column-name FROM table-name WHERE condition), column-names FROM table-name WEHRE conditionCopyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
