FirstSQLTable_student.sql

create database riuf;
use riuf;
create table student(
rollno int,
stdname varchar(255),
age int,
city varchar(255),
);

--insert into table name not database
insert into student(rollno,stdname,age,city)  
values(1,'Nayyab',20,'Faisalabad');

insert into student(rollno,stdname,age,city) 
values(2,'Laiba',21,'Lahore');

insert into student(rollno,stdname,age,city) 
values(3,'rubab',22,'Lahore');

insert into student(rollno,stdname,age,city) 
values(4,'namra',23,'Faisalabad');

insert into student(rollno,stdname,age,city) 
values(5,'saliha',24,'islamabad');

insert into student(rollno,stdname,age,city) 
values(6,'orwa',24,'karachi');

insert into student(rollno,stdname,age,city) 
values(7,'ayesha',25,'multan');

insert into student(rollno,stdname,age,city) 
values(8,'nabia',26,'sialkot');

insert into student(rollno,stdname,age,city) 
values(9,'muniba',27,'pindi');

insert into student(rollno,stdname,age,city) 
values(10,'rafia',27,'sindh');

--to display all the result in table form
select *from student;

--to display particular data within particular column like different students with different ages
select distinct age from student;  

use riuf;
select *from student;

--to display different required column not all (it displays the students with different rollno)
select rollno, stdname from student;

--to display particular different data  within particular column
select distinct city from student;

--Conditional statement
select stdname from student
where age=20;

select rollno from student
where city = 'lahore';

select *from student
where age>20;

-- use keyword (order by) for arranging in ascending order
select *from student
order by age;

--using keyword desc or asc
select *from student
order by age desc;

select *from student
order by city;

--AND operator--
select *from student
where city = 'lahore' AND Age='21';    --here both conditions will be true 

select *from student
where city = 'lahore' AND Age='27';    --here one condition is not true so the result will not be displayed

select *from student
where city = 'lahore' AND Age>'21';

--OR operator--
select *from student 
where city = 'lahore' OR Age='20';      --here if only one condition will be true so the result will be displayed

select *from student
where stdname = 'nayyab' OR Age='20';

select *from student
where stdname = 'nayyab' OR Age= '20' OR city= 'Faisalabad';

--Not operator--
select *from student
where NOT Age='24';

select *from student
where NOT city='lahore';

-- IN operator used to select or display multiple data within same column (compare a single column to multiple values)
select *from student
where city IN ('Lahore' , 'faisalabad' );

-- not in operator
select *from student
where stdname NOT IN ('orwa','laiba');

-- between operator
select *from student
where (age between 20 AND 24);

-- not between operator
select *from student
where age NOT between 20 AND 24;