How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1964
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

Project the all columns from the PURCHASE_ORDER table; limit

This answer was rated:

Project the all columns from the 

 

The-PC-Guy :

Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question

The-PC-Guy :

Which program was your database created in?

JACUSTOMER-d1iyxteq- :

I think xxx

The-PC-Guy :

xxx server?

The-PC-Guy :

it makes a difference for the syntax

JACUSTOMER-d1iyxteq- :

I have more question

The-PC-Guy :

ok, the way this site works is that you ask one question at a time, and when you receive your answer you rate the expert

The-PC-Guy :

you will then have an opportunity to ask me more questions

The-PC-Guy :

via my profile

The-PC-Guy :

but lets address your first question

JACUSTOMER-d1iyxteq- :

okay

The-PC-Guy :

so

The-PC-Guy :

the suppliers 802 and 803

The-PC-Guy :

what is the column heading that is comming from?

JACUSTOMER-d1iyxteq- :

SELECT *

 

 

xxxxxxxxxx

 

 

xxxxxxxxxxxx;

The-PC-Guy :

yes, that is a typical query

The-PC-Guy :

but we need to know the column name

The-PC-Guy :

that the xxx and xxx are in

The-PC-Guy :

so it works correctly

JACUSTOMER-d1iyxteq- :

I was trying this way but it wouldn't work

The-PC-Guy :

yup

The-PC-Guy :

i know why

The-PC-Guy :

and can help you fix it

JACUSTOMER-d1iyxteq- :

okay

The-PC-Guy :

can you tell me what the column name is

The-PC-Guy :

that the xxx and xxx are in

The-PC-Guy :

or all of the other 800 numbers

The-PC-Guy :

ect..

The-PC-Guy :

just need the name of the column

The-PC-Guy :

the xxxxxxx xxxxx xxxxx

The-PC-Guy :

will have a list of all of the column names

JACUSTOMER-d1iyxteq- :

that I couldn't find the question is just like that

The-PC-Guy :

do you have a copy of the actual database?

JACUSTOMER-d1iyxteq- :

I can send you the whole question

The-PC-Guy :

ok, lets try that

JACUSTOMER-d1iyxteq- :

Question 1 [3pts possible]:

xxxxxx Xxxxx xxxxx xxxx xx xxx xxxxxx xxxxx; xxxxxxxx xxxxxxx xxxxxx xxx xxxx Xxxxxx.'

 

 

+CHAR(10)

--

-- SELECT *

 

 

xxxxxxxx

 

 

xxxxxxx

--

GO

 

GO

PRINT

 

 

xxx(10)+'xxxxxxx, xxx xxxx x, xxxxxxx Xxx [3pts possible]:

xxxxxxxxx xxxxxxx xxxx xxxx xxxxxxxxx xxx and xxxx.

Use the OR condition in your WHERE clause.'

 

 

+xxxx(10)

--

-- SELECT *

 

--

GO

 

 

GO

PRINT

 

 

 

Project the all columns from the xxxxxx xxxxx xxx xxxxxxxxxxx xxxx x x xxxx xxxx xxx xxxxx

Use the IN condition in your WHERE clause.'

 

 

 

--

-- SELECT *

 

 

xxxxx xxxxxxxxxx

 

 

xxxxxxx xxxxxxx xxxxxx xxxx;

--

GO

 

 

GO

PRINT

 

 

 

Show the name and title for all employees with an EmpID value less than 6:'

 

 

 

--

-- SELECT *

 

 

 

 

GO

PRINT

 

Display the invoice number and customer ID for all records in the INVOICE table which have a TotalPrice

value less than $100; sort the results by customer ID (in descending order).'

 

--

--

--SELECT INVOICE NUMBER, CUSTOMER ID

 

GO

 

GO

PRINT

 

Show the Type and Version of every stove in the STOVE table - except the ones which are RED or BLUE.

Sort your results in order of Type, then Version; eliminate duplicate values.'

 

--

-- SELECT TYPE, VERSION

 

--

GO

 

GO

PRINT

 

Show the invoice number and total price from the INVOICE table for all of the invoices for customer number 125.

List them in order of invoice date, and re-name the columns using AS.'

 

--

-- [Insert your code here]

--

GO

 

GO

PRINT

 

Get the information for all invoices which have a total price between $100 and $200 (inclusive); show the invoice

number, total price, and employee number. Order the output by invoice number.'

 

 

--

-- [Insert your code here]

--

GO

 

GO

PRINT

 

xxxxxxxxxx

 

xxxxxx

--

-- [Insert your code here]

--

GO

 

GO

PRINT

 

 

Cxxxxxxxxxxxxxxxxxxx

xxxxxxxxxxxxxxxxx xxxxxxxx xxxxxxxxx xxx x x x

(hint: use LIKE and a wildcard).'

 

 

xxxxxx

--

 

 

xxxxx*

 

 

xxxxxxxx

 

 

xxxxxx

GO

JACUSTOMER-d1iyxteq- :

did you get it?

The-PC-Guy :

yes

The-PC-Guy :

that is all the info you have

JACUSTOMER-d1iyxteq- :

yes

The-PC-Guy :

beacuse this is practially impossible without the actual db

The-PC-Guy :

your original question would normally look like this in sql

The-PC-Guy :

SELECT * Fxxxxx xxxx xxxxx xxxxxxxx'

JACUSTOMER-d1iyxteq- :

yes

The-PC-Guy :

what we need is what columnname is

The-PC-Guy :

so i cannot give you complete SQL queries until we get all of the information, or a copy of the database

The-PC-Guy :

if you would like to get that information

The-PC-Guy :

then get back to me

The-PC-Guy :

Iwould be happy to help you then

JACUSTOMER-d1iyxteq- :

i

JACUSTOMER-d1iyxteq- :

how about the other question?

JACUSTOMER-d1iyxteq- :

can you help me please?

The-PC-Guy :

ok

The-PC-Guy :

let me see which ones I can help with

The-PC-Guy :

Question 1 [3pts possible]:

Display each StateProvince value in the CUSTOMER table; eliminate duplicate values in your results.'

 

 

+CHAR(10)

--

-- SELECT *

 

 

FROM CUSTOMER

 

 

ORDERBYSTATEPROVINCE;

--

GO

 

GO

PRINT

The-PC-Guy :

would be

JACUSTOMER-d1iyxteq- :

number 3

The-PC-Guy :

xxxxxx xxxxx xxx xxxxxxxxxxx xxxx x x xxxx xxxx xxx xxxxx

JACUSTOMER-d1iyxteq- :

number 1 and 4 I gat the answer

The-PC-Guy :

3 was the one where we needed more info

JACUSTOMER-d1iyxteq- :

okay can you please try the rest of the question?

The-PC-Guy :

4

The-PC-Guy :

5

The-PC-Guy :

xxxxxx xxxxx xxx xxxxxxxxxxx xxxx x x xxxx xxxx xxx xxxxx

The-PC-Guy :

6

The-PC-Guy :

Sxxxxxx xxxxx xxx xxxxxxxxxxx xxxx x x xxxx xxxx xxx xxxxx

The-PC-Guy :

7

The-PC-Guy :

Show the invoice number and total price from the INVOICE table for all of the invoices for customer number 125.

List them in order of invoice date, and re-name the columns using AS

The-PC-Guy :

Sxxxxxx xxxxx xxx xxxxxxxxxxx xxxx x x xxxx xxxx xxx xxxxx

The-PC-Guy :

8

The-PC-Guy :

Get the information for all invoices which have a total price between $100 and $200 (inclusive); show the invoice

number, total price, and employee number. Order the output by invoice number.'

The-PC-Guy :

SELECT invoice number, total price, employee number FROM whateverthetablenameis WHERE total price >=100 AND total price <= 200 ORDER BY invoice number ASC

The-PC-Guy :

good so far?

JACUSTOMER-d1iyxteq- :

YES

The-PC-Guy :

ok

The-PC-Guy :

let me get you 9 and 10

The-PC-Guy :

then you can pay me

The-PC-Guy :

by rating

The-PC-Guy :

9

The-PC-Guy :

xxxxxx xxxxx xxx xxxxxxxxxxx xxxx x x xxxx xxxx xxx xxxxx (i.e. the Description value begins

with either of those two words - use LIKE and a wildcard to match).'

The-PC-Guy :

inotherwords

The-PC-Guy :

every time the 1000s place changes

The-PC-Guy :

you want a blue bottom border across the row

The-PC-Guy :

and you want that to be done with macro

The-PC-Guy :

is this correct so far?

The-PC-Guy :

sorry wrong question

The-PC-Guy :

working on yours but someone else contacted me at the same time

The-PC-Guy :

@9

The-PC-Guy :

#9

The-PC-Guy :

xxxxxx xxxxx xxx xxxxxxxxxxx xxxx x x xxxx xxxx xxx xxxxx

with either of those two words - use LIKE and a wildcard to match).'

The-PC-Guy :

xxxxxx xxxxx xxx xxxxxxxxxxx xxxx x x xxxx xxxx xxx xxxxx

The-PC-Guy :

#10

The-PC-Guy :

xxxxxx xxxxx xxx xxxxxxxxxxx xxxx x x xxxx xxxx xxx xxxxx

(hint: use LIKE and a wildcard).'

The-PC-Guy :

xxxxxx xxxxx xxx xxxxxxxxxxx xxxx x x xxxx xxxx xxx xxxxx

The-PC-Guy :

that should do it for you

The-PC-Guy :

PLEASE REMEMBER TO RATE MY SERVICE USING THE SMILEYS BENEATH THIS CHAT

The-PC-Guy :

BONUS ALSO APPRECIATED

JACUSTOMER-d1iyxteq- :

how much is that?

The-PC-Guy :

the cost of the question was $45

The-PC-Guy :

that was the value you selected

The-PC-Guy :

rating will not cost you anything additional

The-PC-Guy :

you have the option of adding a bonus if you wish

The-PC-Guy :

if you think I did an exceptionally good job

JACUSTOMER-d1iyxteq- :

you already the money right?

The-PC-Guy :

no

The-PC-Guy :

not until you rate

The-PC-Guy :

that is how the site works

The-PC-Guy :

the smiley faces underneath this chat

The-PC-Guy :

is how you do that

JACUSTOMER-d1iyxteq- :

I don't understand can you explain me please this is my firs time so

The-PC-Guy :

this link explains it all

JACUSTOMER-d1iyxteq- :

do I have to decide how much you can get?

The-PC-Guy :

I am not sure what you see on your screen, I only am a contractor. I do not get paid until you rate using the smileys below this chat

The-PC-Guy :

if you are still confused

The-PC-Guy :

I can send the question to customer service

The-PC-Guy :

or you can contact them at

The-PC-Guy :

Need help? Call our Toll-Free Customer Service

US/Canada 1.888.862.9212
Available 6am to 6pm PST

International
Available 24/7 for calls from outside US/Canada:

Australia 1800-679-634
New Zealand 0800-452-621
United Kingdom 0808-189-0970
The rest of the world 1-925-418-3893

JACUSTOMER-d1iyxteq- :

okay

JACUSTOMER-d1iyxteq- :

I will rate excellent

41670.7435032986
The-PC-Guy and 3 other Microsoft Office Specialists are ready to help you

Related Microsoft Office Questions