count

In this forum you can share stuff related to Oracle 11g, 10g, 9i.
Post Reply
g_suri24
Posts: 22
Joined: Thu Feb 22, 2007 8:39 am
Location: India

count

Post by g_suri24 »

SQL>SELECT COUNT(1) FROM DUAL;

what is the output of this query and how does it happen.Please explain.

thanks in advance.........
amirtai
Posts: 138
Joined: Sat Apr 08, 2006 5:54 pm
Location: Canada
Contact:

Post by amirtai »

SQL> select count(1)
2 from dual;

COUNT(1)
----------
1

Because there's just one column and one row that's why you'll always get 1. Here's what inside the DUAL table.

SQL> select * from dual;

D
-
X

Regards
Amir
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

What exactly the question is? tks
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest