SQL SESSION 1

Session 1 : Client Master

Client_no	Name	City	Pincode	State	Bal_Due
C00001	Ivan Bayross	Bombay	400054	Maharashtra	15000
C00002	Vandana saitwal	Madras	600001	Tamil Nadu	0
C00003	Pramada Jaguse	Bombay	400057	Maharashtra	5000
C00004	Basu Navindgi	Bombay	400056	Maharashtra	0
C00005	Avi Sreedharan	Delhi	100001	New elhi	2000

Problems:

1. Create the table client master as detailed above with assuming data type and size.

2. Insert the above detailed records_master table.

3. Update the table client master and set the name as ‘Ravi Sreedharan’ of client_no ‘C00005’.

4. Update the table client master and set the Bal_due with 10% up of client_no ‘C00003’.

5. Delete all records of client master.

Solution:

1. Create the table client master as detailed above with assuming data type and size.

2. Insert the above detailed records_master table.

3. Update the table client master and set the name as ‘Ravi Sreedharan’ of client_no ‘C00005’.

UPDATE Client_Master

SET [Names] = 'Ravi Sreedharan'

WHERE Client_No='C00005';

 4. Update the table client master and set the Bal_due with 10% up of client_no ‘C00003’.

UPDATE Client_Master

SET Bal_Due = Bal_Due+(Bal_Due*0.1)

WHERE Client_No='C00003';

5. Delete all records of client master.

DELETE *

FROM Client_Master