snig5 - COUNT(BNAME-4 SQL> select min(balance from acc23...

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

View Full Document Right Arrow Icon
Sheet1 Page 1 SQL> create table acc23(bname char(20),accno integer,balance integer) Table created. SQL> insert into acc23 values('kandivali',123,2000) 1 row created. SQL> insert into acc23 values('malad',120,4000) 1 row created. SQL> insert into acc23 values('kandivali',525,5000) 1 row created. SQL> insert into acc23 values('borivali',150,6000) 1 row created. SQL> select avg(balance) from acc23 AVG(BALANCE) ------------ 4250 SQL> select count(bname) from acc23
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: COUNT(BNAME)------------4 SQL> select min(balance) from acc23 MIN(BALANCE)------------2000 SQL> select max(balance) from acc23 MAX(BALANCE)------------6000 SQL> select sum(balance) from acc23 SUM(BALANCE)------------17000 SQL> select bname,avg(balance) from acc23 group by bname Sheet1 Page 2 BNAME AVG(BALANCE)-------------------- ------------borivali 6000 kandivali 3500 malad 4000 SQL>...
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

snig5 - COUNT(BNAME-4 SQL> select min(balance from acc23...

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