Diff between IF and where ?



Diff between IF and where ?..

Answer / 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

More Programming Languages AllOther Interview Questions

how to data grid use in data bind?

1 Answers   HCL,


Write a program that prints the numbers from 1 to 100. But for multiples of three print "Fit" instead of the number and for the multiples of five print "Bit". For numbers which are multiples of both three and five print "FitBit".

1 Answers  


Ordered List tag is

1 Answers  


How to call a C++ function which is compiled with C++ compiler in C code?

1 Answers   Yahoo,


Which tag is used to break a line

3 Answers  


Q1.Write a C program which asks the user for a number between 1 to 9 and shows the  number. If the user inputs a number out of the specified range, the program should  show an error and prompt the user for a valid input.

1 Answers  


4.Write a program to get the string in array and print that? or Without using loop print the array.

3 Answers  


in a VB application, where the data will be stored after manipulation? what is the syntax for that?

1 Answers   TCS,


How you ll create customizing Tcode.

1 Answers   IBM,


1.Describe about your project?

1 Answers  


Corillian's product is a "Component Container." Name at least 3 component

1 Answers  


what is mutex?

4 Answers   Axiom, Blue Star, SQL Star,


Categories