If you want to all alphabet in capital
YOU WANT TO TYPE UPPER AND COLUMN NAME
LIKE: -
(Sppose in your table there already exist sname table )
Q.. Display student name and student in upper case from the table
A. SELECT SNAME, UPPER(SNAME) FROM STUDENT;
YOU WANT TO TYPE UPPER AND COLUMN NAME
LIKE: -
(Sppose in your table there already exist sname table )
Q.. Display student name and student in upper case from the table
A. SELECT SNAME, UPPER(SNAME) FROM STUDENT;
No comments:
Post a Comment