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

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

Question Posted / vikram

Answer Posted / vikram

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

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is use of package in pl sql?

945

How do you know if a relationship is 2nf?

877

What is sql basics?

987

What is a sql*loader control file?

1156

What is oracle sql called?

859

What do you understand by pl/sql packages?

1017

Why is sql better than hql?

920

List the various privileges that a user can grant to another user?

987

What is oracle and pl sql?

1075

Explain dml and ddl?

919

What is the most common sql injection tool?

991

define sql update statement ? : Sql dba

1048

Is mariadb a nosql database?

1004

Which are the different case manipulation functions in sql?

952

how can we submit a form without a submit button? : Sql dba

916