New Text Document - SQL> insert into br32...

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

View Full Document Right Arrow Icon
Sheet1 Page 1 SQL> select name from br32 where name in (select name from de32) NAME ---------- Deepak Mukesh Nimitt SQL> select * from de32 NAME ACCNO ---------- ---------- Nimitt b-21 Mukesh b-17 Deepak b-15 SQL> select * from br32 NAME LOANNO ---------- ---------- Nimitt b-32 Mukesh b-28 Deepak b-25 SQL> select name from br32 where name not in (select name from de32) no rows selected
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: SQL> insert into br32 values('Harshit','b-27') 1 row created. SQL> select name from br32 where name not in (select name from de32) NAME----------Harshit SQL> select name from br32,ac32 where br32.loanno=ac32.loanno and branch='Borivali' an ect name from de32) NAME----------Nimitt Sheet1 Page 2 SQL> commit 2 Commit complete. SQL>...
View Full Document

Page1 / 2

New Text Document - SQL> insert into br32...

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