Under what circumstances would you code a SELECT construct instead of IF statem

Under what circumstances would you code a SELECT construct
instead of IF statements?

Question Posted / sasguru

4 Answers
15402 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Under what circumstances would you code a SELECT construct instead of IF statements?..

--when you have a long series of mutually exclusive
conditions and comparison is numeric
--CPU time is reduced when using SELECT statements

Is This Answer Correct ?

12 Yes

0 No

Under what circumstances would you code a SELECT construct instead of IF statements?..

Answer / sumalatha.ch

select statement is reduced cpu time.and make the programme
easier to read and debug

Is This Answer Correct ?

2 Yes

0 No

Under what circumstances would you code a SELECT construct instead of IF statements?..

Answer / 3nadh

Select Statement executes one of several statements or
group of statements.

If Statement :- Continues processing only those obs that
meet the condition.

Is This Answer Correct ?

0 Yes

3 No

Under what circumstances would you code a SELECT construct instead of IF statements?..

Answer / jothi sankar

--> When renaming of varibales during getting data itself,

--> new varible creation by combining already existing
varibales(eg: Name = FName + LName) to reduce memory usage

--> When nested conditions are less and getting more %
records from base

Is This Answer Correct ?

0 Yes

4 No

Post New Answer