adspace


Diff between IF and where ?

Answer Posted / Nirmal Jeet Kaur

In SQL, 'IF' is not a keyword. Instead, use conditional statements like CASE WHEN or IF EXISTS. The 'WHERE' clause is used to filter the records based on specific conditions. In programming languages like VBScript or JavaScript, 'IF' is used for conditional execution and 'WHERE' is not applicable.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the diff bw sql direct and jdbc update can't we do select and updating operation in sql direct

2231


please any one pass file aid,xpeditor and endeavor tools

2410


Give examples of macro quoting function?

2067


hi This is radhika.Can anyone help me to know the question papers of NATIONAL INFORMATICS CENTRE for the post of scientific officer/engineer? if anyone know plz tell me question paper pattern

2171


I want sample papers for NIC Examination. Plz send them to my mail Id das.neelam@gmail.com . Plz send it today, tomorrow i've the exam.

2098


hi, all this is shoba m.c.a . i have learned abap but no oppurtunities right now as fresher , right now i want to learn any course on demand any one pls suggest me good course and institute in hyderabad

1870


what is class module in vb6? what it's use? with example..

2511


Please forward important interview and basic questions in VB6 on my email id: usneha_16@yahoo.co.in

2105


If u need any fake experience certificate in software side, contact me at: vikramyadhav@gmail.com

8413


How to get the index of the clicked field in reports in ABAP?

1763


Hi Guys, This is Rama, right now I am working as a Software Test Engineer in Gurgoan and I have over all 3 years of testing expoeriance. Right now I am looking for a change. Can any body help me out to find a job in south india. Thanks in Advance

1949


Compare any 4 software development life cycle paradigms with each other. Indicate at least one application for each of the paradigms that are suitable to developed using that paradigm.

2905


Bonjour, svp je veut voir comment envoyer un mail en java et comment changer le droit d'accé d'un fichier en java: de lecture en lecture/écriture et merci d'avance ;)

2300


I am taking the bmc control m/enterprise manager 7.0 scheduling test and just wanted to see what kind of questions they would ask or if anyone has taken the test and how long it is for how many questions?

6214


can we extend a class having only one parameterised constructor.Suggest the process to do it.

2572