Question

Observe the given Table TEACHER and give the output of question (i) and (ii)

TEACHER_CODE TEACHER_NAME DOJ

T001 ANAND 2001-01-30

T002 AMIT 2007-09-05

T003 ANKIT 2007-09-20

T004 BALBIR 2010-02-15

T005 JASBIR 2011-01-20

T006 KULBIR 2008-07-11

(i) SELECT TEACHER_NAME, DOJ FROM TEACHER WHERE

TEACHER_NAME LIKE “%I%‟

(ii) SELECT * FROM TEACHER WHERE DOJ LIKE “%-09-%
​

Answer 1

Answer:

what is this.

I don't understand your question.

Answer 2

i) AMIT 2007-09-05

ANKIT 2007-09-20

BALBIR 2010-02-15

JASBIR 2011-01-20

KULBIR 2008-07-11

ii) T002 AMIT 2007-09-05

T003 ANKIT 2007-09-20