0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

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 FirstName from #Students;
select distinct FirstName from #Students;
select top 10 percent *  from #Students;

fork query

edited sep 18 20

created sep 18 20 anonymous