Assume the database given below

 

mainTable (rowid INTEGER, puid INTEGER)

 

Assume main table be

 

Rowid Puid

1                     2

2                     3

3                     4

4                     6

5                     7

6                     8

 

 

"select  rowid from mainTable where Puid = 2 OR puid = 8 OR puid = 7 OR
puid = 3"

 

Will the result of the above query be (1, 6, 5, 2) or (1, 2, 5, 6)?

 

Using which query we can get the result (1, 6, 5, 2)?

 

Regards,

Phani

 

    

 

 

 

 

Reply via email to