select max(rownum) from table-name; Here rownum is a keyword which can g

With out using count() function. How to the find total
number of rows in a table?

Question Posted / subbarayulu neela

Answer Posted / subbarayulu neela

select max(rownum) from table-name;

Here rownum is a keyword which can gives unique number for
individual rows.

Is This Answer Correct ?

35 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Where can I learn sql for free?

501

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

535

What is sql select statement?

503

Can we use loop in sql?

532

what is user defined functions? : Sql dba

545

Explain what is rdbms?

580

Explain the update statement in sql

558

how to see the create table statement of an existing table? : Sql dba

521

What is snowflake sql?

578

what is a table in a database ? : Sql dba

539

How do I write a cron which will run a sql query and mail the results to agroup?

524

What is dense_rank in sql?

539

What is the difference between execution of triggers and stored procedures?

548

How do I view a table in sql?

541

What do you understand by case manipulation functions?

541