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
9972 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

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1924

How to execute the package in oracle?

1050

How to define a cusotmer as a supplier in ORACLE R12

2188

How to add another datafile to a tablespace?

1002

How to name query output columns in oracle?

1145

Is java required for oracle client?

938

How to store pictures on to the database?

931

What is a table index?

1026

How are extents allocated to a segment?

1080

How to display row numbers with the records?

1037

How to install oracle database 10g xe?

974

What is a sub query and what are the different types of subqueries?

1083

WHAT IS ecc 6.0

2112

How to use fetch statement in a loop?

988

What is a snapshot in oracle database?

980