I need to find out how many projects there are in the project table in sql query format

Question

PROJECT
P_ID    PROJECT_NAME    CLIENT_ID   MGR_ID  PARENT_P_ID
1   Hardware Support Intranet   2   105  
2   Hardware Support Interface  2   103 1
3   Hardware Support Database   2   102 1
4   Teller Support System   4   105  
5   Internet Advertising    6   105  
6   Network Design  6   104 5
7   Exploration Database    5   102

Answer 1

0

assuming one project per row...

select count(*) as c from project

answered Mar 24 '10 at 02:33 PM

user-1392
71 ● 1

(comments are locked)

I need to find out how many projects there are in the project table in sql query format

Follow this question

Related Questions