Learn basic understanding from W3C school

[dineshbalaji]

Focus on SQL Database topic and Close it once finish particular topic.

[dineshbalaji]

in - used with "where" to match with n number of values

Ex: select * from table1_name where col1 in (select col from talbe2_name);

on '' - provides conditional case like 'where' operator in 'table joining'.

table1 inner join table2 on conditions

as -

1. used for provide alias name for table/column
2. used with create procedure.
   3. used with create view
   4. create table from copy of another table

[dineshbalaji]

basic topic are covered and update in SQL folder