View previous topic :: View next topic
|
Author |
Message |
janardhana Reddy
New User
Joined: 20 Oct 2004 Posts: 17 Location: Bangalore
|
|
|
|
Hi all
I am getting the result for for the following query.
Select * from table_name;
now gettig the error in fetching the no. of rows from the below query.
select count(*) from table_name;
What does it mean ? |
|
Back to top |
|
|
unna
New User
Joined: 15 Oct 2004 Posts: 17
|
|
|
|
Hi Jana,
count * in the select statement will display the number of rows in a tableand will not fetch the rows from the table.
Regards, |
|
Back to top |
|
|
janardhana Reddy
New User
Joined: 20 Oct 2004 Posts: 17 Location: Bangalore
|
|
|
|
Hi Unna,
not getting the result for the query select count(*) from table name |
|
Back to top |
|
|
mmwife
Super Moderator
Joined: 30 May 2003 Posts: 1592
|
|
|
|
Hi Janardhana,
Try this:
select count(*) as rcdcnt from table_name; |
|
Back to top |
|
|
janardhana Reddy
New User
Joined: 20 Oct 2004 Posts: 17 Location: Bangalore
|
|
|
|
Hi all,
My query is Select count(*) from se_number;
and not getting result for the above query.
Getting the rows for Select * from Se_number;
Finally i got the reason , no index exists for that table. |
|
Back to top |
|
|
|