select sum(1) from emp;

without using count(*) and rownum how can we count total
record in a table

Question Posted / ganesh prasad sial

5 Answers
10173 Views
AC, HP, I also Faced
E-Mail Answers

Answer Posted / ganesh prasad sial

select sum(1) from emp;

Is This Answer Correct ?

38 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to get a create statement for an existing table?

969

Explain an index segment?

1118

How to bring a tablespace offline?

1064

Can the query output be sorted by multiple columns in oracle?

992

What is an oracle cursor variable?

1075

What is oracle join syntax?

1003

How to create a stored procedure in oracle?

1103

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1044

How do we display rows from the table without duplicates?

972

How do I reset a sequence in oracle?

1098

Why should I use oracle database?

991

Define oracle database

1044

How oracle handles dead locks?

1066

Can we create trigger on materialized view in oracle?

992

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2827