/    /  DBMS – Between Clause 

Between Clause 

 

With between, the data can be selected, where for a given attribute one can define the range for its values to be given as output.

 The output contains both maximum and minimum values of range.

 Consider the ‘FACULTY’ relation.

  

FNo D-No   D-Name  FName Qual 

22 21  CSE Alex Ph.D. 

24 22  IT Ria  MTech

25 22  IT  Ben MTech

27 23  ECE Becca MTech

30 23  ECE Alice  MTech

33 24 ME  Lex  Ph.D.

35 24 ME  Maggie Ph.D.

37 25 EEE Max MTech

39 25 EEE Bec MTech

————————————————————-

 

 Example-1 :Find all the tuples from the ‘faculty’ relation, where the

D-No is greater than or equal to 22 and less than or equal to 24.

 

   Select *

   From Faculty

   Where DNo>=22 and DNo<=24 ;

 

This can be written as :

  

   Select *

   From faculty

   Where DNo between 22 and 24 ;

 

Output :

   R4 :  FACULTY 

———————————————— 

FNo FName DNo Qual

———————————————–

24 Ria  22 MTech

25 Ben  22 MTech

27 Becca 23 MTech

30 Alice 23 MTech

33 Lex 24     P.hD

35 Maggie 24 P.hD

———————————————-

 

Here, the output contains six tuples.

Reference

Between Clause