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 are the advantages of normalization?

1074

what is the difference between group by and order by in sql? : Sql dba

1113

If a cursor is open, how can we find in a pl/sql block?

1154

What is data profiling in sql?

1066

What is update query?

972

Can we join 3 tables in sql?

1026

How does postgresql compare to oracle/db2/ms sql server/informix?

1024

Does sql view stored data?

947

What is trigger and how to use it in sql?

1017

Is mariadb nosql?

1036

What is pls_integer in pl sql?

1091

tell us something about heap tables. : Sql dba

1091

What is difference between stored function and application function?

1187

Is sql a dbms?

992

How to execute a stored procedure?

1080