Home > IT Answers > SQL Server > Question on SQL 2005 table
Vijaykumar456
25 pts.
 Question on SQL 2005 table
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
ASKED: December 10, 2010  8:39 PM
UPDATED: December 11, 2010  3:59 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  May 13, 2013  10:46 pm  by  Chris Leonard   2,945 pts.
All Answer Wiki Contributors:  Chris Leonard   2,945 pts. , carlosdl   63,580 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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…

Vijaykumar456
 25 pts.
 

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…

Vijaykumar456
 25 pts.
 

I’m pretty sure that the idea behind homework is that to research it and figure out how to do it.

Denny Cherry
 64,550 pts.
 

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.

Subhendu Sen
 22,125 pts.
 

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.

carlosdl
 63,580 pts.