In the WHERE clause what is BETWEEN and IN? - BETWEEN supplies a range of values while IN supplies a list of values.

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

MAINFRAME

DB2

DETAILS

Question: In the WHERE clause what is BETWEEN and IN?

Answer: BETWEEN supplies a range of values while IN supplies a list of values.

Category	DB2 Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 8928 users
Added on	9/8/2014
Views	68448
Rate it!

Question: In the WHERE clause what is BETWEEN and IN?

Answer:

BETWEEN supplies a range of values while IN supplies a list of values. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	What is the restriction on using UNION in embedded SQL?	View Answer
	What is UNION,UNION ALL?	View Answer
	What is the use of VALUE function?	View Answer
	How do you concatenate the FIRSTNAME and LASTNAME from EMP table to give a complete name?	View Answer
	How do you retrieve the first 5 characters of FIRSTNAME column of EMP table?	View Answer
	My SQL statement SELECT AVG(SALARY) FROM EMP yields inaccurate results. Why?	View Answer
	Can you use MAX on a CHAR column?	View Answer
	How do you find the maximum value in a column?	View Answer
	What are aggregate functions?	View Answer
	How do you select a row using indexes? ?	View Answer
	How do you eliminate duplicate values in SELECT? ?	View Answer
	How would you find out the total number of rows in a table? ?	View Answer
	How do you eliminate duplicate values in SELECT? ?	View Answer
	How would you find out the total number of rows in a table? ?	View Answer
	9. Can the OCCURS clause be at the 01 level?	View Answer
	7. What does the IS NUMERIC clause establish ?	View Answer
	110) What is auditing?	View Answer
	109) How do I create a table MANAGER ( EMP#, MANAGER) where MANAGER is a foreign key which references to EMP# in the same table? Give the exact DDL.	View Answer
	108) What are the disadvantages of using VARCHAR?	View Answer
	107) When would you prefer to use VARCHAR?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All DB2 Interview Questions & Answers - Exam Mode / Learning Mode