English

Write query based upon item table given. Display students' name starting with letter "K".

Advertisements
Advertisements

Question

Write query based upon item table given.

Students

Adno Name Average Sex Scode
501 R.Jain 98 M 111
545 Kavita 73 F 333
705 K.Rashika 85 F 111
754 Rahul Goel 60 M 444
892 Sahil Jain 78 M 333
935 Rohan Saini 85 M 222
955 Anjali 64 F 444
983 Sneha Aggarwal 80 F 222

Display students' name starting with letter "K".

Code Writing
Advertisements

Solution

SELECT * FROM Students WHERE Name LIKE 'K%';
shaalaa.com
  Is there an error in this question or solution?
Chapter 10: Structure Query Language - EXERCISE [Page 200]

APPEARS IN

CBSE Computer Science with Python [English] Class 12
Chapter 10 Structure Query Language
EXERCISE | Q 28. (vii) | Page 200
Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×