exp6 - insert into rishi values(1,'Rishi',10000) insert...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 create table rishi(Sr_no int,C_Name varchar(30),Amt int) select * from rishi insert into rishi values(1,'Rishi',10000) insert into rishi values(2,'Thakur',5000) insert into rishi values(3,'Paradox',99000) select distinct Amt from rishi as T,Amt as S where T.Amt>S.Amt ans S.Amt= create table rishi(Sr_no int,C_Name varchar(30),Amt int) insert into rishi values(1,'Rishi',10000) insert into rishi values(2,'Thakur',5000) insert into rishi values(3,'Paradox',99000) select * from rishi create table rishi1(Sr_no int,C_Name varchar(30),Amt int) insert into rishi1 values(1,'Rishi',10000) insert into rishi1 values(2,'Thakur',5000) insert into rishi1 values(3,'Paradox',99000) select * from rishi1 select * from rishi select * from rishi1 select distinct C_Name from rishi where C_Name in(select C_NAme from rishi1) select distinct C_Name from rishi1 where C_Name not in(select C_NAme from rishi) create table rishi(Sr_no int,C_Name varchar(30),Amt int)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: insert into rishi values(1,'Rishi',10000) insert into rishi values(2,'Thakur',5000) insert into rishi values(3,'Paradox',99000) select * from rishi create table rishi1(Sr_no1 int,C_Name1 varchar(30),Amt1 int) insert into rishi1 values(1,'Rishi',10000) insert into rishi1 values(2,'Thakur',5000) insert into rishi1 values(3,'Paradox',99000) insert into rishi1 values(4,'R',70000) select * from rishi1 select * from rishi select * from rishi1 select distinct C_Name1 from rishi1 where C_Name1 in(select C_NAme from rishi) select distinct C_Name1 from rishi1 where C_Name1 not in(select C_NAme from rishi) Sheet1 Page 2 drop table rishi drop table rishi1 select * from rishi select * from rishi1 select distinct Sr_no,C_NAme,Amt,Sr_no1,C_Name1,Amt1 from rishi as T,rishi1 as S where T.Amt<>S.Amt1 select distinct Sr_no,C_NAme,Amt,Sr_no1,C_Name1,Amt1 from rishi as T,rishi1 as S where T.Amt<S.Amt1...
View Full Document

This note was uploaded on 10/25/2010 for the course CMPN SEM4 taught by Professor Thakur during the Spring '07 term at University of Mumbai.

Page1 / 2

exp6 - insert into rishi values(1,'Rishi',10000) insert...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online