count(1) will give the count of the numbr of records in the table. count(

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

Question Posted / munni

Answer Posted / munni

count(1) will give the count of the numbr of records in the
table. count(1) is faster than count(*) since the count is
not based on all the fields.

Is This Answer Correct ?

13 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the different transaction levels available in transaction control transformation?

1119

What is complex mapping?

1068

What if the source is a flat-file?

1041

What is rank transformation in informatica

1108

What is mapping debugger?

944

What is the difference between STOP and ABORT options in Workflow Monitor?

1177

What is the status code in stored procedure transformation?

1119

What is meant by incremental aggregation?

1021

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

991

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1089

What are the different types of repositories created using informatica?

1060

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

965

What is the procedure for creating independent data marts from informatica 7.1?

1000

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2468

What is the maplet?

1040