select count(1) from <table_name>; By this also we can count no of

How do u count no of rows in a table?

Question Posted / bj

Answer Posted / bj

select count(1) from <table_name>;

By this also we can count no of rows in a table.

Is This Answer Correct ?

19 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is dialect in sql?

949

Is sql pronounced sequel or sql?

1269

What is a natural join sql?

977

What is cte?

983

Does sql support programming?

1074

What is dba in sql? : SQL DBA

1044

What do you understand by exception handling in pl/sql?

1035

What are database links used for?

1048

How many types of functions are there in sql?

955

What does over partition by mean in sql?

979

How do you sort in sql?

1027

What is offset and limit in sql?

1059

What are the advantages of pl sql?

1122

What is trigger and how to use it in sql?

1021

What are the indexing methods?

1049