Home » Other » Training & Certification » SQl Query Urgent
SQl Query Urgent [message #280751] Wed, 14 November 2007 11:50 Go to next message
greentree
Messages: 1
Registered: November 2007
Junior Member
name | gadget
--------+-------------
Mike | computer
Mike | keyboard
Mike | keyboard
Mike | mouse
Mike | mouse
Steve | computer
Steve | phone
Anton | computer
Anton | keyboard
Anton | mouse
Anton | TV
Alex | TV
Alex | mouse
Alex | phone
Alex | computer


Some specific name is given as the input.
Please write SQL statement(s) which returns list of names of the persons having set of unique gadgets which is equal to or greater than the person whose name was given.


Examples:

input: Mike
output: Anton
Mike has (computer, keyboard, mouse).
Anton has more gadgets: (computer, keyboard, mouse) + TV.
Re: SQl Query Urgent [message #280752 is a reply to message #280751] Wed, 14 November 2007 11:55 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
read & FOLLOW posting guidelines as stated in above URL
Re: SQl Query Urgent [message #280802 is a reply to message #280751] Wed, 14 November 2007 15:12 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
and it's not URGENT that we do your homework for you.

What have you tried ?
Re: SQl Query Urgent [message #280840 is a reply to message #280751] Thu, 15 November 2007 00:10 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Look at analytic function.
Previous Topic: what is difference between stored procedure and plsql
Next Topic: syllabus required
Goto Forum:
  


Current Time: Thu Mar 28 04:07:36 CDT 2024