SQL in Query

--sal for employee wages

SELECT * from EMP;

--Query user information for wages equal to 1500 or 3000 or 5000

SELECT * from emp where Sal in (1500, 3000, 5000);
SELECT * from emp where Sal = $ or Sal = N or sal = 5000;

--Check the salary is not the user information of && && 5000

SELECT * from emp where SAL isn't in (1500, 3000, 5000);
SELECT * from emp where sal! =, and Sal! =-and Sal! = 5000;
SELECT * from emp where Sal <> the and Sal <> and Sal <> 5000;

--the database does not equal two representations:! = <>

SQL in Query