Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
rv498
Yak Posting Veteran
60 Posts |
Posted - 2014-03-10 : 13:13:20
|
Find the total number of customers who are single. Be sure to name each derived field.-----so there is a column named "MaritalStatus". However, this question is not asking a query because next question asks me to provide query to check the solution. This question is asking me to name each derived field. What does it mean by derived? |
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2014-03-10 : 15:20:04
|
Don't know where you got this kind of questions..."Field" is not the commonly used term. It is more a column than a "field". A column in a row...However - if you are doing a count() you will have no column header (i.e. "field name") so give it a name like this example:select count(*) as cntStatusSingle from customers where MaritalStatus = 'single' Too old to Rock'n'Roll too young to die. |
 |
|
rv498
Yak Posting Veteran
60 Posts |
Posted - 2014-03-10 : 15:21:30
|
thanks webfred |
 |
|
|
|
|