How to count the no of records of a table without using COUNT function?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

How to count the no of records of a table without using
COUNT function?

Question Posted / subashpanda

11 Answers
26782 Views
TCS, Tesco, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to count the no of records of a table without using COUNT function?..

Answer / kart

select max(rownum) from table

Is This Answer Correct ?

65 Yes

5 No

How to count the no of records of a table without using COUNT function?..

Answer / l meher

select max(rownum) from table_name;

Is This Answer Correct ?

24 Yes

0 No

How to count the no of records of a table without using COUNT function?..

Answer / sandeep

select max(rownum) from table_name;

Is This Answer Correct ?

4 Yes

2 No

How to count the no of records of a table without using COUNT function?..

Answer / ajit

declare
cursor c1
is
select * from emp;
i c1%rowtype;
begin
open c1;
loop
fetch c1 into i ;
exit when c1%notfound;
end loop;
dbms_output.put_line(c1%rowcount);
close c1;
end;

Is This Answer Correct ?

2 Yes

0 No

How to count the no of records of a table without using COUNT function?..

Answer / satya

select sum(1) from table_name;

Is This Answer Correct ?

4 Yes

3 No

How to count the no of records of a table without using COUNT function?..

Answer / senthil kumar

Hi Ramaprasad 'select max(rownum) from emp; ' this is passible
but

declare
cursor c1(dpno emp.deptno%type)is select * from emp where
deptno=dpno;
i c1%rowtype;
begin
open c1(dpno);
loop
fetch c1 into i ;
exit when c1%notfound;
dbms_output.put_line(c1%rowcount);
end loop;
close c1;
end;

this is NOT Passible , because this one just show all records Not count it.......

Is This Answer Correct ?

0 Yes

1 No

How to count the no of records of a table without using COUNT function?..

Answer / vikram

select col1,col2,1 as SNO,sum(sno) from emp
group by 1,2,3

Is This Answer Correct ?

0 Yes

1 No

How to count the no of records of a table without using COUNT function?..

Answer / suneelkumar

Hi guys..

rownum is virtual column we con't use max(rownum) i t will
give the error unknown colum...

so by using cursor we can count

Is This Answer Correct ?

0 Yes

2 No

How to count the no of records of a table without using COUNT function?..

Answer / ramaprasad

select rownum from emp;
select max(rownum) from emp;

declare
cursor c1(dpno emp.deptno%type)is select * from emp where
deptno=dpno;
i c1%rowtype;
begin
open c1(dpno);
loop
fetch c1 into i ;
exit when c1%notfound;
dbms_output.put_line(c1%rowcount);
end loop;
close c1;
end;

Is This Answer Correct ?

1 Yes

4 No

How to count the no of records of a table without using COUNT function?..

Answer / kart

using select command
select * from xxx; we will get the no of rows at bottom
if the feedback is unset

then use the plsql with cursor;

select rownum from table; the last value
is the number of records

Is This Answer Correct ?

4 Yes

9 No

Post New Answer