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
10155 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 create a stored program unit?

1224

What is define in oracle?

1060

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1994

How to apply filtering criteria at group level in oracle?

1042

What is a nvl function? How can it be used?

1029

Why do we need oracle client?

945

What is a nvl function?

1021

Differentiate between pre-select and pre-query?

1104

What types of joins are used in writing subqueries?

982

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2207

Explain table?

1109

How to establish administrator authentication to the server?

1039

Explain oracle’s server parameter file.

989

How to use regular expression in pattern match conditions in oracle?

1039

How to update values in a table in oracle?

1026