SQL Queries

SQL Queries
1. How to select data from a table ?

select column_name1,column_name2 from table_name;

select *from table_name;

2. How to select distinct columns or values from a table ?

select distinct column_name from table_name;

3. How to use where condition ?

select colum_name from table_name where column_name operator value;

select marks from students where marks > 60;

select *from emp where name ='yogi'

4. How to use AND operation ?

select column_name from table_name where column_name1 operator value and Column_name2 operator value

5. How to use OR operatos ?
select column_name from table_name where colum_name1 operator value or Column_name2 operator value