SQL Query to print Week days.

Revati S Misra 430 20 Dec 2024

Write an SQL Query to print all the days of the week.

Revati S Misra

Student

Skilled in SEO, content writing, and digital marketing. Completed several years of working in many organizations including multinational companies. I love to learn new things in life that keep me motivated.

1 Answers

Ashutosh Patel 20 Dec 2024

To print all the days of the week, you can use the recursive CTE. Here is the basic SQL Query to find all the week-days from Monday to Saturday,

USE your_database
GO
WITH CTE_WeekDay(Number, WeekDays) AS 
(
SELECT 0, DATENAME(DW, 0)
UNION ALL
SELECT Number+1, DATENAME(DW, Number+1) FROM CTE_WeekDay WHERE Number < 6
)
SELECT WeekDays FROM CTE_WeekDay

Output:

forum

SQL Query to print Week days.

Can you answer this question?

1 Answers