Hi Everyone,
The below image is the Employee Attendance details in a table , How do i count the number of Present(P), Absent(A) and Week off(WO) days for a particular Employee using SQL
Thanks in advance...
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Please try the below query.
VARSHA
Thank you for the answer @Ashish Sahay
I used the same query as u suggested with some changes, Instead of "," i used "+" for SUM and used where clause.
Its working....
Vinish Kapoor
Please provide the table structure of this table and the dummy data so that can create a query for you.
VARSHA
Thanks for the reply Vinish,
I tried with Query as Ashish Sahay suggested with some changes , it's working