Oracle sub query

5 pts.
Tags:
Oracle
Oracle Query
I need to display the names of male and female programmers. I have name as a field in the programmer table and now depending on the sex I have to display the names separately. Can you help me out with the query?


Software/Hardware used:
oracle 10g
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    I can most likely help, but you need to provide a little more information.

    What do you mean by "separately"?  Do you want 2 different resultsets, or a single resultset but ordered by gender, or something else?

    Also, please post the exact structure of your table, some example data, and the exact results you would expect from that sample data.

    The solution is probably simple, but the requirement must be understood first.
    85,390 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: