Home » SQL & PL/SQL » SQL & PL/SQL » Basic Query (merged)
Basic Query (merged) [message #232580] Sat, 21 April 2007 08:14 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member



HI,

I have a table structure.

lecturer Stream
------------------
L1 Mpc
L2 Mpcc
L3 Mpc

I want lecturer those are taken in Mpec.

Output:

Lecturer:

L1
L3

I want basic query .Any body Help me..Pls

Regards,
Arunkumar




Basic query [message #232581 is a reply to message #232580] Sat, 21 April 2007 08:15 Go to previous messageGo to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member



HI,

I have a table structure.

lecturer Stream
------------------
L1 Mpc
L2 Mpcc
L3 Mpc

I want lecturer those are taken in Mpc.

Output:

Lecturer:

L1
L3

I want basic query .Any body Help me..Pls

Regards,
Arunkumar




Re: Basic query [message #232582 is a reply to message #232581] Sat, 21 April 2007 08:36 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Show us what you tried first, and use code tags to make it more readable.
Re: Basic query [message #232584 is a reply to message #232581] Sat, 21 April 2007 08:40 Go to previous messageGo to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
I hope you are going to do some studying yourself, because as far as I understand your question this is a bit to easy to ask for:
select lecturer from <table> where stream='Mpc'


again : start reading some basic sql courses.

Re: Basic query [message #232585 is a reply to message #232584] Sat, 21 April 2007 08:48 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
What did you spoon feed him the answer? This person has not shown that they can even look in a manual for the most basic of questions.
Re: Basic query [message #232586 is a reply to message #232585] Sat, 21 April 2007 09:17 Go to previous message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
Hi,

I understand what you are saying.
But.... it's a nice day here, and I didn't do my good deed today.

Personally I don't like answers like "Go and search" or "Google for it" so much. If someone asks something to simple or to obvious or to stupid, mostly I decide not to answer at all (no answer is also an answer) and sometimes I do answer. If I do answer I believe it shoukd be informative and helpful.

maybe it's a ego-thing.
My ego gets bigger when I help someone Laughing

Anyway, I hope the man/woman was helped (is that english?)

Have a nice day Cool

Martijn
Previous Topic: Query View
Next Topic: Hi Guys Please help me in removing this bug...
Goto Forum:
  


Current Time: Fri Dec 09 23:02:50 CST 2016

Total time taken to generate the page: 0.05978 seconds