WITH Clause In SQL | How To Use WITH CLUSE In MS SQL SERVER | Write Query Using WITH CLAUSE In SQL

WITH Clause In SQL How To Use WITH CLUSE In MS SQL SERVER Write Query Using WITH CLAUSE In SQL

#sql #mssql #sqlserver

query- WRITE A QUERY FOR TABLE WHERE EACH RECORD IS HIGHER THAN
AVERAGE SALARY

sql script

DROP TABLE emp
CREATE TABLE emp
( emp_ID INT
, emp_NAME VARCHAR(50)
, SALARY INT)

INSERT INTO emp VALUES(101, 'Mohan', 40000),
(102, 'James', 50000),
(103, 'Robin', 60000),
(104, 'Carol', 70000),
(105, 'Alice', 80000),
(106, 'Jimmy', 90000),

Solution Script

WITH AVERAGE_SALARY (AVG_SAL) AS
(SELECT CAST(AVG(SALARY) AS INT) FROM EMP)
SELECT*FROM
EMP E,AVERAGE_SALARY AM
WHERE E.SALARY LESS AM.AVG_SAL

If you get error by using above solution code, please watch video in fast forward till end

I am Mr. Surani ,Data Science Aspirant. I will teach you different technical hacks to horn up your expertise on Python, R , Data Science, Machine Learn, Tableau, Apache, MS Excel. Photoshop Tutorials, Adobe Premiere m Adobe After effects , MS Words, Power Points , Windows Hacks etc

Please, Like , Share and hit bell icon in Channel. Thank you

sql,mysql,ms sql,sql tutorial,learn sql,sql for beginners,interview sql,data analytics sql,sql data analytics,sql tutorial for beginners,sql basics,sql course,sql training,sql videos,sql crash course,sql beginners,sql full course,free sql course,sql basics for beginners,introduction to sql,learn sql fast,learn sql for beginners,sql beginner,basic sql,sql basics tutorial,sequel,sql commands,SELECT,Simple SQL Queries,SQL Queries,SQL operators

#Excel #MSEXCEL #MSSQL #SQL #Server