shilpak10

• May 2nd, 2007

 

Select count(*) from table_name

shilpak10

 Profile Answers by shilpak10 Questions by shilpak10

• May 2nd, 2007

 

select count(*) from table_name

sampra

 Profile Answers by sampra 

• Feb 14th, 2008

 

select count(*) from table_name

Altaf Hussain Sayyed

 Profile Answers by Altaf Hussain Sayyed 

• Jun 29th, 2011

 

Hi,

Select count(COLUMN_NAME) from information_schema.columns where table_name='table_name';

In above query please put your table name in place of 'table_name'


If you need any further assistance or discussion please mail me at altafhsayyed@yahoo.com

Thanks and regards

Bhagya Killi

 Profile Answers by Bhagya Killi 

• Jun 14th, 2016

 

Select count(*) from table name

Anupam Kumar

• Jan 7th, 2018

 

SELECT COUNT(*) FROM table_name;