exp3 - select *from rishi 1RISHI1000 2AGARWAL7000...

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(001,'RISHI',10000) select *from rishi 1RISHI10000 insert into rishi values(001,'AGARWAL',50000) select *from rishi 1RISHI10000 1AGARWAL50000 update rishi set Amt=1 select *from rishi 1RISHI1 1AGARWAL1 update rishi set Amt=1000 where C_Name='RISHI' select *from rishi s 1RISHI1000 1AGARWAL1 update rishi set Sr_no=002 where C_Name='AGARWAL' select *from rishi 1RISHI1000 2AGARWAL1 insert into rishi values(003,'DRAGON',50000) insert into rishi values(004,'CS',20000) select *from rishi 1RISHI1000 2AGARWAL1 3DRAGON50000 4CS20000 update rishi set Amt=7000 where C_Name='AGARWAL'
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: select *from rishi 1RISHI1000 2AGARWAL7000 3DRAGON50000 4CS20000 select avg(Amt) from rishi 19500 Sheet1 Page 2 update rishi set Sr_no=001 where C_Name='AGARWAL' select *from rishi 1RISHI1000 1AGARWAL7000 3DRAGON50000 4CS20000 select avg(Amt) from rishi where Sr_no=1 4000 select min(Amt) from rishi 1000 select max(Amt) from rishi 50000 select max(Amt),max(Sr_no) from rishi 500004 select sum(Amt) from rishi 78000 select sum(Amt),sum(Sr_no) from rishi 780009 select count(Amt) from rishi 4 select Sr_no,avg(Amt) from rishi group by Sr_no 14000 350000 420000...
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

exp3 - select *from rishi 1RISHI1000 2AGARWAL7000...

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