• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

count(*) as rcount problem

 
Raj Bhandari
Ranch Hand
Posts: 97
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
I'm having this strange problem:



Any suggestions ? I just want to know the count of rows in my table.
Thanks
 
Sulbha Jan
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This works for me:

 
Raj Bhandari
Ranch Hand
Posts: 97
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Sorry, my mistake.
I was doing select count(*) as rcount from table1 where col1=...
and my col1 was spelt wrong.
Thanks for the reply.
Regards.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic