(8) What are the purpose of two wild card character used with like clause.
2
3. (a) Write SQL commands for the questions from (i) to (xii) on the basis of table SCHOLARS 1x12-12
Adm_No Name Address
Join DT
Semester Grade
1256
ADITYA B-4, DWARKA
2012-07-23 45000 1
AL
5678
AMIT
SEC 5, R.K PURAM
2014-06-15
36000
1425
KARINA
2013-06-22
C1
B3/2, V.VIHAR
IL
26000
BIKRAM
8954
SEC 2, PUNA
2012-03-13
75000
I
A2
1789
VIJAY
35000
Il
BI
2014-02-17
123/A, MUMBAI
22000
III
8376
2012-10-05
C3
GANESH
53/2, CHANDIGARH
25000
2012-06-24
II
B2
2938
ARUN
11/7, CHENNAI
32000
2011-05-25
1
AL
6498
TANU
117-N, DELHI
44000
2014-02-30
III
B2
5420
56-E, AHEMADABAD
RAJAN
2012-08-22
38000
1
C2
8567
73/C, FARIDABAD
ANITA
NO
ENTE
Number)
Number(3)
