d2jsp
Log InRegister
d2jsp Forums > Off-Topic > Computers & IT > Programming & Development > Question About Sql Statement
Add Reply New Topic New Poll
Member
Posts: 28,358
Joined: Jun 10 2006
Gold: 7,663.12
Warn: 10%
Sep 26 2014 09:13am
could use some help. One of the questions popped up on a practice test was:
Which one of the following is a valid SQL statement? Please explain why you made your selection.
a. Get Sales from dbo.SalesTable AS Sum(Sales) where Sales > ‘50’
b. Select Sum(Sales) from dbo.SalesTable
Retired Moderator
Posts: 18,570
Joined: Feb 27 2004
Gold: 11,858.00
Trader: Trusted
Sep 26 2014 10:00am
Quote (billykid989 @ Sep 26 2014 10:13am)
could use some help. One of the questions popped up on a practice test was:
Which one of the following is a valid SQL statement?  Please explain why you made your selection.
a.  Get Sales from dbo.SalesTable AS Sum(Sales) where Sales > ‘50’
b.  Select Sum(Sales) from dbo.SalesTable


The answer is B.

You don't select things from a database using 'Get'. That's just one thing wrong.

This post was edited by Blind[zF] on Sep 26 2014 10:00am
Member
Posts: 11,637
Joined: Feb 2 2004
Gold: 434.84
Sep 26 2014 10:42am
Quote (billykid989 @ Sep 26 2014 10:13am)
could use some help. One of the questions popped up on a practice test was:
Which one of the following is a valid SQL statement?  Please explain why you made your selection.
a.  Get Sales from dbo.SalesTable AS Sum(Sales) where Sales > ‘50’
b.  Select Sum(Sales) from dbo.SalesTable


Have you made any effort to answer this for yourself?
Go Back To Programming & Development Topic List
Add Reply New Topic New Poll