OraFAQ Forum: SQL & PL/SQL » Re: SQL Count Statement

Blog
Search
Help
Members
Register
Login
Home

Home » SQL & PL/SQL » SQL & PL/SQL » Re: SQL Count Statement

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: SQL Count Statement [message #20391]

Mon, 20 May 2002 14:47

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

SQL> select sal,comm from emp;

SAL COMM
---------- ----------
800
1600 300
1250 500
2975
1250 1400
2850
2450
3000
5000
1500 0
1100
950
3000
1300

14 rows selected.

SQL> select count(nvl(comm,0)) from emp;

COUNT(NVL(COMM,0))
------------------
14

1 row selected.

SQL>

Report message to a moderator

Previous Topic:	Insert Source table name on insert event
Next Topic:	Update statements from multiple tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 10 03:18:04 CDT 2024