How do i start my car without a key? :-)
GJ, March 11, 2018 - 2:43 pm UTC
A reader, March 12, 2018 - 4:28 pm UTC
"How we can find employee count department wise from emp table without using count function"?
Why would you want or need to?
March 13, 2018 - 2:20 am UTC
When it says:
"Student Notebook: Question 7: How we can find employee count department wise from emp table without using count function"?
:-)
Count without using COUNT function
John Gasch, March 13, 2018 - 3:36 pm UTC
Option 3: For all practical purposes, SUM(1) is equivalent to COUNT(*), so it can be done just using a simple select statement. To satisfy the requirement of "using a plsql block", simply wrap the select statement inside a function. Keep it simple!
March 14, 2018 - 6:25 am UTC
Good point.