Exp6 - Rishi 10000 2 Thakur 5000 3 Paradox 99000 4 R 70000 select distinct C_Name1 from rishi1 where C_Name1 in(select C_NAme from rishi

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

View Full Document Right Arrow Icon
RISHI AGARWAL ROLL NO 02 SE CMPN A 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); 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 rishi; SR_NO C_NAME AMT ---------- ------------------------------ ---------- 1 Rishi 10000 2 Thakur 5000 3 Paradox 99000 select * from rishi1; SR_NO1 C_NAME1 AMT1 ---------- ------------------------------ ---------- 1
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: Rishi 10000 2 Thakur 5000 3 Paradox 99000 4 R 70000 select distinct C_Name1 from rishi1 where C_Name1 in(select C_NAme from rishi); C_NAME1-------------Paradox Rishi Thakur select distinct C_Name1 from rishi1 where C_Name1 not in(select C_NAme from rishi); C_NAME1-----------R select distinct * from rishi as T,rishi1 as S where T.Amt=S.Amt1; 1 Rishi 10000 1 Rishi 10000 2 Thakur 5000 2 Thakur 5000 3 Paradox 99000 3 Paradox 99000 select distinct * from rishi as T,rishi1 as S where T.Amt<=S.Amt1; 1 Rishi 10000 1 Rishi 10000 1 Rishi 10000 3 Paradox 99000 1 Rishi 10000 4 R 70000 2 Thakur 5000 1 Rishi 10000 2 Thakur 5000 2 Thakur 5000 2 Thakur 5000 3 Paradox 99000 2 Thakur 5000 4 R 70000 3 Paradox 99000 3 Paradox 99000...
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 - Rishi 10000 2 Thakur 5000 3 Paradox 99000 4 R 70000 select distinct C_Name1 from rishi1 where C_Name1 in(select C_NAme from rishi

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