Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

a query for barrowed books

happy10319Mar 23 2008 — edited Mar 25 2008

Hi,
I have a table that shows the people who have barrowed a book :

book_id	user_id	date_barrowed	date_returned
16	340	01/05/1998	05/05/1998
16	340	20/02/2007	25/02/2007
17	340	01/05/1998	05/10/1998
17	450	04/12/1998	
23	500	20/02/2007	25/02/2007
65	510	18/03/2008	
76	7540	05/07/2008	10/07/2008

How can I query those who have presently barrowed a book that they have already barrowed before ?
Thank you.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 22 2008
Added on Mar 23 2008
12 comments
1,649 views