Question

write a query to display the student id and address for the student "David"Ans: select student_id, address from student where student_name=Lower('david')or student_name=upper('david');​

Answer 1

Answer:

Functions for Use in SELECT and WHERE Clauses

A select_expression or where_definition in a SQL statement can consist of any expression using the functions described next.

An expression that contains NULL always produces a NULL value unless otherwise indicated in the documentation for the operators and functions involved in the expression.