Scribd
Upload
2 views1 page

SQL Question

The document contains a list of SQL questions focused on manipulating student data. It includes tasks such as combining and formatting names and phone numbers, extracting specific characters, and altering case for names and cities. The questions aim to enhance skills in SQL queries related to string functions and data presentation.

Uploaded by

kashvidudeja
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2 views1 page

SQL Question

The document contains a list of SQL questions focused on manipulating student data. It includes tasks such as combining and formatting names and phone numbers, extracting specific characters, and altering case for names and cities. The questions aim to enhance skills in SQL queries related to string functions and data presentation.

Uploaded by

kashvidudeja
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

SQL QUESTION(S)

1. Display student name and city together in one column separated by a hyphen.

2. Display a greeting message “Hello <Name>” for each student.

3. Combine Name and Phone in a single column.

4. Display the first 3 characters of each student’s name.

5. Extract the last 4 digits of the phone number.

6. Display the middle 2 characters of the student’s name.

7. Display all student names in lowercase.

8. Display all city names in uppercase.

9. Convert Name to uppercase and City to lowercase in the same query.

10. Remove leading spaces from the Name field.

11. Remove trailing spaces from the Name field.

12. Remove spaces from both sides of the Name field.

13. .Display Name in uppercase along with City in lowercase in one column.

14. Extract first 2 characters of Name and convert them to uppercase.

15. Remove spaces from Name and display it with City in uppercase.

16. Display only the first 5 characters of City.

17. Combine trimmed Name and Phone in a single column.

18. Display Name after removing spaces and converting to lowercase.

You might also like