Scribd
Upload
31 views2 pages

SQL Basics

The document contains a series of tasks related to data manipulation and querying. It includes instructions for displaying last names, counting values in a column, extracting specific numbers, filtering employees by hire date, handling leap years, replacing commas, fetching specific rows, and identifying employees who joined on the same date. Each task is focused on different aspects of data retrieval and formatting.

Uploaded by

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

SQL Basics

The document contains a series of tasks related to data manipulation and querying. It includes instructions for displaying last names, counting values in a column, extracting specific numbers, filtering employees by hire date, handling leap years, replacing commas, fetching specific rows, and identifying employees who joined on the same date. Each task is focused on different aspects of data retrieval and formatting.

Uploaded by

Saranya Venugopal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 2

1 Display LAST NAME alone from the below list

KARTHI P
BHUVI P
HARI
MOHAN S
VINAY

2 Display the number of values present in the below column

MARKS
12,34,55,98
87,34
23,54,67
12,23,23,24,34

3 Display the below numbers alone from a column

11,22,33,44,55,66,77,88,99

4 Display the employees who got hired in April month

5 How to display employees who joined on leap years

6 How to replace multiple commas into single comma

7 How to fetch 55th to 60th rows in a table based on row_id column

8 Display employees who joined on the same date

You might also like