How to count rows in sql query

How to count no. of rows retrieved from select statement of sql query.
Posted by Prince Mahajan 3/23/2014 10:35:48 AM
Total Answers : 2
Answer 1
Your sql query will be like :
select count(*) from table_name
Posted by StepCoder Team 3/25/2014 9:41:43 AM
Answer 2
You can use count function for counting the number of rows in a sql statement.. You query will become something like this :
select count(*) from talbe1 where name ='harish sharma'
Posted by Andrew Dvorkin 3/26/2014 4:50:10 PM
Post your answer
Preview
Sign in to your account
Your Email : 
Password :   
Forgot your password
Don't have StepCoder account ?
Create a new account
 
Follow me on twitter
About Me
Harpreet Singh
I began programming with C++ when i was 17. Then at the middle of my study .NET came. Then I began to read C# and VB.NET. By the time i learnt SQL and ASP.NET, and developed some websites such as news portals that are active now. Currently i am running my own Software company.
Answer these questions! If you know the answer.