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 view? Can we update view

1442

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1078

Why is the cursor important?

1046

How do I find duplicates in a single column in sql?

1022

What is a pdo connection?

1045

how many sql dml commands are supported by 'mysql'? : Sql dba

1125

What do you understand by pl/sql cursors?

1090

what are sequences

1753

What is basic structure of pl sql?

1074

What is user in sql?

1027

What are few of the schema objects that are created using PL/SQL?

1040

What is union and union all keyword in sql?

1044

What is sql server and ase?

1028

How do I make sql search faster?

1001

How are functions and procedures called in PL/SQL?

1236