Question on SQL 2005 table

25 pts.
Tags:
SQL 2005
SQL Server 2005
SQL Server tables
SQL tables
tablename:-software

pname             packagename                    cost

MARY               README                             1200 ANAND             PARACHUTES                     6000 ANAND             VIDEO TITLING                   16000 JULIANA           INVENTORY                        3500 KAMALA           PAYROLL PKG                    20000 MARY                FINANCIAL ACCT             85000 MARY               CODE GENERATOR          20000 PATTRICK        README                            1200 QADIR               BOMBS AWAY                 3000 QADIR               VACCINES                      3100 RAMESH             HOTEL MGMT                35000 RAMESH               DEAD LEE                    4500 REMITHA              PC UTILITIES                5000 REMITHA               TSR HELP PKG             6000 REVATHI             HOSPITAL MGMT           75000 VIJAYA               TSR EDITOR                      7000

 

My Question is:-

Display each pname,costliest package name and cheapest package name developed by him or her...?

This query should run in sqlserver 2005...



Software/Hardware used:
sql server 2005

Answer Wiki

Thanks. We'll let you know when a new response is added.

Thank you for visiting ITKE.

We are happy to help you with solving specific IT questions, but need as
much information as possible to do so. Let us know about the problem you
are trying to solve, how you are approaching it and what work you’ve
done so far, and we can help guide you in the right direction.

Discuss This Question: 5  Replies

 
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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Vijaykumar456
    tablename:-software pname packagename cost MARY README 1200 ANAND PARACHUTES 6000 ANAND VIDEO TITLING 16000 JULIANA INVENTORY 3500 KAMALA PAYROLL PKG 20000 MARY FINANCIAL ACCT 85000 MARY CODE GENERATOR 20000 PATTRICK README 1200 QADIR BOMBS AWAY 3000 QADIR VACCINES 3100 RAMESH HOTEL MGMT 35000 RAMESH DEAD LEE 4500 REMITHA PC UTILITIES 5000 REMITHA TSR HELP PKG 6000 REVATHI HOSPITAL MGMT 75000 VIJAYA TSR EDITOR 7000 My Question is:- Display each pname,costliest package name and cheapest package name developed by him or her...? This query should run in sqlserver 2005...
    25 pointsBadges:
    report
  • Vijaykumar456
    tablename:-software pname packagename cost MARY README 1200 ANAND PARACHUTES 6000 ANAND VIDEO TITLING 16000 JULIANA INVENTORY 3500 KAMALA PAYROLL PKG 20000 MARY FINANCIAL ACCT 85000 MARY CODE GENERATOR 20000 PATTRICK README 1200 QADIR BOMBS AWAY 3000 QADIR VACCINES 3100 RAMESH HOTEL MGMT 35000 RAMESH DEAD LEE 4500 REMITHA PC UTILITIES 5000 REMITHA TSR HELP PKG 6000 REVATHI HOSPITAL MGMT 75000 VIJAYA TSR EDITOR 7000 My Question is:- Display each pname,costliest package name and cheapest package name developed by him or her...? This query should run in sqlserver 2005...
    25 pointsBadges:
    report
  • Denny Cherry
    I'm pretty sure that the idea behind homework is that to research it and figure out how to do it.
    66,365 pointsBadges:
    report
  • Subhendu Sen
    I agree with Mrdenny, this might be a part of his/her course related. As per Carlosdl answer, he provided the almost same to a earlier Q.
    29,780 pointsBadges:
    report
  • carlosdl
    Well, I was not sure and that´s why I decided not to post a direct answer but a link to another question where the OP could see an example which he/she had to understand and modify in order to get the answer.
    70,220 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following