Scribd
Upload
12 views16 pages

Essential SQL Functions and Use Cases

The document outlines various SQL functions and their use cases, including counting rows, summing values, calculating averages, and finding maximum and minimum values. It also covers string manipulation functions, such as combining strings, extracting portions, and trimming spaces. Additionally, it addresses date functions for extracting parts and calculating differences between dates.

Uploaded by

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

Essential SQL Functions and Use Cases

The document outlines various SQL functions and their use cases, including counting rows, summing values, calculating averages, and finding maximum and minimum values. It also covers string manipulation functions, such as combining strings, extracting portions, and trimming spaces. Additionally, it addresses date functions for extracting parts and calculating differences between dates.

Uploaded by

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

Mostly

Asked
SQL
functions

- By Sakshi Yadav
Use Case: Counts the number of rows in a dataset.
Use Case: Adds up values in a numeric column.
Use Case: Calculates the average value of a
numeric column.
Use Case: Finds the maximum value in a column.
Use Case: Finds the minimum value in a column.
Use Case: Rounds a numeric value to a specified
number of decimal places.
Use Case: Combines two or more strings into one
string.
Use Case: Returns the length of a string.
Use Case: Extracts a portion of a string.
Use Case: Removes leading and trailing spaces
from a string.
Use Case: Converts a string to uppercase or
lowercase.
Use Case: Returns the first non-null value from a
list of expressions.
Use Case: Creates conditional logic in SQL queries.
Use Case: Extracts a specific part of a date.
Use Case: Calculates the difference between two
dates.

You might also like