Write SQL statements to do the following: (a) Using the three sep… - Vidyadip

Question

Write SQL statements to do the following:

(a) Using the three separate words "We,""study,"and "MySQL,"produce the following output: "We study MySQL "

(b) Use the string "Internet is a boon "and extract the string "net ".

(c) Display the length of the string "Informatics Practices ".

(d) Display the position of "My "in "Enjoying MySQL ".

(e) Display the name of current month.

✓

Answer

Get the step-by-step solution for this question inside the Vidyadip app.

Get the answer in the app

Need a full question paper?

Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.

Start Generating Free

Explore more

More "3 Marks Each" from Structured Query Language (SQL) – II→Structured Query Language (SQL) – II — all question types→Computer Science STD 12 Science question papers→CBSE Board STD 12 Science question papers→CBSE Board question paper generator→

Similar questions

Out of the following, which is the fastest (i) wired and (ii) wireless medium of communication? Infrared, Coaxial Cable, Ethernet Cable, Microwave, Optical Fiber

What is Worm? How is it removed?

Write a python program to draw the line chart for the following:

x_data = [2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2013]

y_data = [18, 21, 18, 21, 16, 14, 13, 18, 17, 16, 19, 23]

Write two advantages of 4G over 3G Mobile Telecommunication Technologies in terms of speed and services.

Assuming the given data prepare the Horizontal bar chart.

Degree=["M.A.", "M.B.A"," M.Com."," M.Sc."," M.Tech."]

Enrollment=[878677,416325, 271266, 519159, 257361]

Write a script to create a list of 10 integers and then display all using loop.

Find the output:

Differentiate between PAN and LAN types of networks.

Write a program to save the following records in laps1.csv. ADMNO NAME AGE 1151, Ajay, 12 1152, Chandrika, 14

What is Trojan Horse?