Learn Sql server in hindi/urdu part-4 (Not Operator and Order By Clause)

select * from student --display all data



select  id,name,contactnumber from student --display selected column



select * from student where batchcode='1208c1' -- where clause with one column



select * from student where name='emad' and batchcode='1708c1' and id=1003 --where clause with and operator



select * from student where batchcode='1708c1' or batchcode='120c1'



select * from student order by name  desc



select * from student order by name  asc



select * from student order by id desc



select * from student where batchcode!='1707b1' and batchcode!='1610c1'





select * from student where batchcode!='1707b1' or batchcode!='1610c1'





select * from student where batchcode not in ('1707b1','1610c1','1502c1')



select * from student where id not in (1002,1003,1004,2,4)