Oracle SQL Practical question SQL to Find number of saturday and sunday

Oracle SQL Practical question SQL to Find number of saturday and sunday

[karnarajmahajan]

I'm​ become addicted to your channel. Every night before sleeping I watch your lecture.

[sujaa]

Thanks Siva, I learned a lot in this video and I am learning the tricks and different ways to use logic now, appreciate your selfless service to many who want to learn SQL, PL/SQL and crack interviews.
Regards,

Sujaa

[lbgx]

The way you organize the lecture and explain every step logically is just amazing. Keep making these videos sir. Thank you so much.

[Im_aviik]

Many thanks Siva for sharing your experience and Hard Work !!!! ... " THINK AND APPROACH FOR EXPECTED OUTPUT " is just impeccable

[gauravdutta]

Hi Sir,

I have created the same with just a small diff - ' using with by clause' like you did in some other videos

WITH D AS(select C_DATE, TO_CHAR(C_DATE, 'DAY') AS C_DAY from
(select trunc(SYSDATE, 'MONTH') + level -1 C_DATE from DUAL
connect by level <= LAST_DAY(TRUNC(SYSDATE)) - trunc(SYSDATE, 'MONTH') + 1))
SELECT C_DAY, COUNT(*) NO_OF_DAYS FROM D WHERE C_DAY like 'S%' GROUP BY C_DAY ;

[aniketjagdale]

Thanks so much sir it was a great and easy explanation. I understood many concepts from this.Thanks a lot

[rahulmittal]

Siva..you are simple the best !
Learned a lot through your videos.

[janardhanakasibisi]

Thank you so much for helping so many people in this way....

Once again thankyou so much my dear sweet siva brother...

[mugilans]

Great. Expecting performance tuning videos

[tsreekant]

Hi Siva thanks a lot for posting such a nice stuff...Are you giving classes as well? These posts are really very much helpful.

[petermarquesliveLIVE]

Sir, start suscription model on youtube. The amount of knowledge you're giving is immense and i want to support you. keep making more videos

[rampradeepkalivarapu]

Thank you...for making me strong with your knowledge....tq...

[VinayKumar-ijeu]

Thanks a lot Siva, got to learn new concepts everyday!!

[masalhemant]

Sir Nice Video i learn Sir please upload the performance tuning video

[erannagoud]

Hi Shiva one request please make video on performance tuning and query optimization concept in video

[gurub]

sir, i have followed the same thing but i searched with full name of the day, I couldn't get the output.
empty table as query output. If i filtered with to_char(h, 'DY') in ('SAT', 'SUN'). It is working.when i do with to_char(h, 'day') in ('saturday', 'sunday') it is not working. Can you clarify this please.

select
to_char(h, 'day') day,
count(*)
from
(
select trunc(sysdate, 'MONTH')+(level-1) h
from dual
connect by level<=last_day(trunc(sysdate))-trunc(sysdate, 'MONTH')+1
)
where
to_char(h, 'day') IN ('saturday', 'sunday')
group by
to_char(h, 'day');

[nsnreddy]

Is this code will work out for every month or only for May?

[parihardeepak]

Dear Sir, How can we the Week wise data by passing any date of the particular week.

[debayan]

Hi Siva, your videos are logical, structured and concise. No doubt, one of the best materials i have found on youtube, thank you so much!! wish you all the best and keep creating such informative content. Looking forward to your future videos.

[arj-ongjanlaksana]

I have a question, If I find week in month, how to write SQL Query in oracle?