count(1) means it will count based on 1st column in the select statement

select count(1) from emp? what is the o/p?

Question Posted / chandu

Answer Posted / chandu

count(1) means it will count based on 1st column in the
select statement

Is This Answer Correct ?

14 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what is $$$$?

2203

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1211

what is index?how it can work in informatica

2083

What is target load order?

1298

What are different types of transformations available in informatica?

1058

what is degenerated dimension?

4093

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1128

Differentiate between Load Manager and DTM?

2214

tell me 5 session failure in real time how can you solve that in your project?

2390

Enlist the advantages of informatica.

1099

Why update strategy and union transformations are active? Explain with examples.

1284

What are multi-group transformations?

1165

What is the cumulative sum and moving sum?

1235

What are the prerequisite tasks to achieve the session partition?

1295

What is expression transformation?

1145