0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users and developers of distributed applications built on top of the blockchain operating system, EOS.IO

CREATE TABLE #Students (
StudentId int,
FirstName varchar(20),
LastName Varchar(20),
Email Varchar(20),
Gender Char(1),
PNo int,
Address Varchar(30) 
)
insert into #Students values (101,'Deeps','Gurr','[email protected]','F',232323,'Peets street');
insert into #Students values (102,'Anu','Mer','[email protected]','F',546789,'Hello street');
insert into #Students values (103,'Apps','Gurr','[email protected]','F',546343,'Velo street');
insert into #Students values (104,'Sur','Gur','[email protected]','F',762323,'Indiana street');
insert into #Students (StudentId,FirstName,Gender)
values(105, 'Chaithu','M') 
insert into #Students values (106,'Sur','Gurla','Surn@gur;a.com','M',8772323,'Henda street');
select * from #Students where Address is not null;
select * from #Students where FirstName like 'D__p%s';
select * from #Students where StudentId between 102 and 105;
select  * from #Students where   StudentId in (102,103,104) ;
select  * from #Students where  Not StudentId = 102 ;
select distinct FirstName from #Students;
select top 10 percent *  from #Students;

fork query

edited sep 18 20

created sep 18 20 anonymous