ewang1205
asked on
sql to return 0 when no row found
I like the following select to return 0 when no row found. Thanks.
select emp_id from emp where emp_id =30;
emp_id
10
20
select emp_id from emp where emp_id =30;
emp_id
10
20
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.