Gettig error in fetching the no of rows in SQL

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 ?

unna · New User Joined: 15 Oct 2004 Posts: 18

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,

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

mmwife · Super Moderator Joined: 30 May 2003 Posts: 1493

Hi Janardhana,

Try this:

select count(*) as rcdcnt from table_name;

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.