Basic Sql,select Statements

SQL language is not case sensitive.

SQL can be written on one line or multiple lines of keywords cannot be abbreviated or branch clauses are usually written in a branch.

Use indentation to improve the readability of the statement.

SELECT statement

For example table: Scott.emp

SELECT * from SCOTT. EMP where comm > sal;

* Represents a wildcard character. Represents all Columns

Select Sal,comm from scott.emp where ename = ' WARD ';

Note: ename is a string so note its capitalization.

SELECT * from scott.emp where ename like ' s% ';

Select *from scott.emp where Deptno in (10,20);

Select *from scott.emp where comm is not null;

Select sal+10000, ename, job,empno from Scott.emp;

SELECT * FROM [select * from Scott.emp where empno>7600] where deptno in (20,30);

Basic Sql,select Statements