Nucleus Software Exports Interview Question: In a company, employees mark ... | Glassdoor

Interview Question

Software Engineer Interview Noida (India)

In a company, employees mark their attendance and it is

  stored in a table . How will you find number of present & absent employees in a single query
Tags:
pl sql
Answer

Interview Answer

1 Answer

0

Select status,count(1) as pre_ab from attendance group by status

+----+--------+--------+
| id | name | status |
+----+--------+--------+
| 1 | sushil | p |
| 2 | vijay | p |
| 3 | nikhil | p |
| 4 | test | a |
| 5 | kamal | a |
| 6 | ram | p |
+----+--------+--------+

sushil k bhaskar on May 8, 2015

Add Answers or Comments

To comment on this, Sign In or Sign Up.