Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Write a SQL statement that will return all the Sales Orders for the Salespersons’ with the name starting with ‘John’. Expand / Collapse
Author
Message
Posted Tuesday, July 2, 2013 5:58 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 29, 2013 2:56 AM
Points: 16, Visits: 20
Write a SQL statement that will return all the Sales Orders for the Salespersons’ with the name starting with ‘John’.

Below are the example tables that you will be retrieving data from:

Transactions:

* Sales Order

* Order Quantity

* Order Total

* Order Date

* SalesPersonID

* ProductID

SalesPerson

* SalesPersonID

* SalesPersonName

Product

* ProductID

* ProductName
Post #1469423
Posted Tuesday, July 2, 2013 6:11 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:55 AM
Points: 12,881, Visits: 31,817
the format of your question screams "copy and paste" from your homework;

That's a little frowned upon here, so lets do it right:
can you show us the query you've created so far, and explain what doesn't work, or where you are stuck?
we would love to help you master the problem, rather than do it for you;

you'll suffer later if you don't grasp this concept yourself, because later homework will certain build on top of the basics like this.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1469432
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse