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

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

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a record in pl/sql?

1216

What is clustered and nonclustered index in sql?

985

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1630

What are the two different parts of the pl/sql packages?

1139

How to place comments in pl/sql?

1215

What is the difference between union and union all command?

1151

How do you remove duplicate records from a table?

979

What are the two virtual tables available at the time of database trigger execution?

1271

What is %type in sql?

1019

What are stored procedures in mysql?

1073

What will you get by the cursor attribute sql%rowcount?

1076

How do you bind variables in pl sql?

1159

What are user defined functions?

1063

Explain isolation levels. : Transact sql

1106

Why coalesce is used in sql?

1067