What is the difference between IN and BETWEEN, that are used inside a WHERE clause?

Ads
 

What is the difference between IN and BETWEEN, that are used inside a WHERE clause?

What is the difference between IN and BETWEEN, that are used inside a WHERE clause?

View Answers

November 19, 2010 at 5:45 PM

Hi,

The BETWEEN clause is used to fetch a range of values, whereas the IN clause fetches data from a list of specified values.

Thanks,

Ads









Related Tutorials/Questions & Answers:
What is the difference between the >> and >>> operators?
what is the difference between extends and implements
Advertisements
what is the difference between extends and implements
what is the Difference between weblogic and jboss?
what is the difference between pop and oop
What is the difference between hibernate and spring
What is the difference between $message and $$message?
What is difference between Path and Classpath?
What is the difference between a JDK and a JVM?
What is the difference between a constructor and a method?
What’s the difference between load() and get()?
what is the difference between distributed application and web application?
What is difference between singleton and prototype bean?
What is the difference between JSF, Servlet and JSP?
What is the difference between JPA and Hibernate?
what is the difference between productList==null and productList.size()==0
What are difference between Bean Factory and Application Context ?
What is the difference between the Boolean & operator and the && operator?
What is the difference between GET and POST method?
What is the difference between Big Data and Hadoop?
What is the difference between Big Data and Hadoop?
What is difference between UNIX Hosting and Window Hosting?
What is the difference between component and tag in JSF?
Difference between struts and JSF
What is the difference between a break statement and a continue statement?
What is the difference between an if statement and a switch statement?
What is difference between JDK,JRE and JVM?
What is difference between Core Java and Advanced Java?
What is difference between Core Java and Advanced Java?
what is the difference between jdk 1.4 and 1.5 and 1.6
what is the difference between access specifiers and access modifiers in java?

Ads