 |
|
|
|
Next: SQL Server 2005 Catalog Metadata Cache
|
| Author |
Message |
External
Since: Jun 15, 2008
Posts: 9
|
(Msg. 1) Posted: Tue Aug 19, 2008 9:40 am
Post subject: ON SELECT STATEMENT
Archived from groups: microsoft>public>sqlserver>server (more info?)
|
|
|
Here's the database:
The database scheme consists of four tables:
Product(maker, model, type)
PC(code, model, speed, ram, hd, cd, price)
Laptop(code, model, speed, ram, hd, screen, price)
Printer(code, model, color, type, price)
model should be the key.
Question:
Exercise: 23
Find the makers producing at least both a pc having speed not less
than 750 MHz and a laptop having speed not less than 750 MHz.
Result set: Maker
Can anyone give a hint please???
Thanks!! |
|
| Back to top |
|
 | |
External
Since: Jun 15, 2008
Posts: 9
|
(Msg. 2) Posted: Tue Aug 19, 2008 9:59 am
Post subject: Re: ON SELECT STATEMENT [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Jan 10, 2008
Posts: 39
|
(Msg. 3) Posted: Tue Aug 19, 2008 10:05 am
Post subject: RE: ON SELECT STATEMENT [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Here is a hint: You need to use join to get your result set. Don't expect
much hint. This is a home work you are supposed to solve.
Read on "Joining Tables" topic in SQL Server Books Online.
"Yue" wrote:
> Here's the database:
>
> The database scheme consists of four tables:
> Product(maker, model, type)
> PC(code, model, speed, ram, hd, cd, price)
> Laptop(code, model, speed, ram, hd, screen, price)
> Printer(code, model, color, type, price)
>
> model should be the key.
>
> Question:
>
> Exercise: 23
> Find the makers producing at least both a pc having speed not less
> than 750 MHz and a laptop having speed not less than 750 MHz.
> Result set: Maker
>
>
>
> Can anyone give a hint please???
>
> Thanks!!
> >> Stay informed about: ON SELECT STATEMENT |
|
| Back to top |
|
| |
External
Since: Jun 15, 2008
Posts: 9
|
(Msg. 4) Posted: Tue Aug 19, 2008 4:06 pm
Post subject: Re: ON SELECT STATEMENT [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
THANK YOU, DXC. 
YEP, I GOT IT OUT. ^___^
IT'S NOT A HOMEWORK THOUGH, IT'S A EXERCISE I FOUNT ONLINE JUST TO
LEARN SQL MYSELF. =)
THANKS THOUGH.
On 8月19日, 下午1时05分, DXC wrote:
> Here is a hint: You need to use join to get your result set. Don't expect
> much hint. This is a home work you are supposed to solve.
>
> Read on "Joining Tables" topic in SQL Server Books Online.
> >> Stay informed about: ON SELECT STATEMENT |
|
| Back to top |
|
| |
External
Since: Sep 01, 2010
Posts: 1
|
(Msg. 5) Posted: Wed Sep 01, 2010 9:25 am
Post subject: Reply [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hi ,
Can you please tell me the solution?
I have got the right answer but it says use second database..
Thanks in advance
> On Tuesday, August 19, 2008 1:05 PM DX wrote:
> Here is a hint: You need to use join to get your result set. Don't expect
> much hint. This is a home work you are supposed to solve.
>
> Read on "Joining Tables" topic in SQL Server Books Online.
>
>
>
> "Yue" wrote:
>> On Thursday, August 21, 2008 11:35 PM Yue wrote:
>> Here's the database:
>>
>> The database scheme consists of four tables:
>> Product(maker, model, type)
>> PC(code, model, speed, ram, hd, cd, price)
>> Laptop(code, model, speed, ram, hd, screen, price)
>> Printer(code, model, color, type, price)
>>
>> model should be the key.
>>
>> Question:
>>
>> Exercise: 23
>> Find the makers producing at least both a pc having speed not less
>> than 750 MHz and a laptop having speed not less than 750 MHz.
>> Result set: Maker
>>
>>
>>
>> Can anyone give a hint please???
>>
>> Thanks!!
>>> On Thursday, August 21, 2008 11:35 PM Yue wrote:
>>> SOLVED IT!!!
>>>
>>> HAHAHA!!! HAPPY!
>>>> On Thursday, August 21, 2008 11:36 PM Yue wrote:
>>>> THANK YOU, DXC.
>>>> YEP, I GOT IT OUT. ^___^
>>>> IT'S NOT A HOMEWORK THOUGH, IT'S A EXERCISE I FOUNT ONLINE JUST TO
>>>> LEARN SQL MYSELF. =3D)
>>>>
>>>> THANKS THOUGH.
>>>>
>>>> On 8=D4=C219=C8=D5, =CF=C2=CE=E71=CA=B105=B7=D6, DXC <D... RemoveThis @discussions.micr=
>>>> osoft.com> wrote:
>>>> Submitted via EggHeadCafe - Software Developer Portal of Choice
>>>> Scrolling in WPF Toolkit?s Column Chart
>>>> http://www.eggheadcafe.com/tutorials/aspnet/0939d60c-8e17-4a27-b898-1f...2d2d6f6 >> Stay informed about: ON SELECT STATEMENT |
|
| Back to top |
|
| |
External
Since: Jan 11, 2008
Posts: 157
|
(Msg. 6) Posted: Wed Sep 01, 2010 5:25 pm
Post subject: Re: Reply [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Wed, 01 Sep 2010 12:49:04 GMT, dinkar joshi
wrote:
>Hi ,
>
>Can you please tell me the solution?
>I have got the right answer but it says use second database..
>
>Thanks in advance
>
So what is the question? You would be better off starting a new thread
and putting down everything including DDL and example data, along with
your attempted solution.
John >> Stay informed about: ON SELECT STATEMENT |
|
| Back to top |
|
| |
| Related Topics: | select statement - Hi, I tried to run a sql select statement query like the following in SQL 2005 management studio: select * from table where field.value = a Then I get hang up and it is running and running and never end. So I trie...
Getting Nulls from a select/where statement - I am trying to get the nulls from my columns and when I do a select/where statement I do not get anything. I have used Null, NULL, IS NULL, IS NOT NULL. What is the right thing to use? I am using SQL 2005 Enterprise. Thank you Dee
SELECT statement operator *= - What does this syntax mean? It is used in a SQL Server view ( v2000 ) as part of a where clause. I cannot find anything showing a " *= " comparison. I an find " != ", and many others, but not " *= ". If it is not clea...
SQL SELECT statement help - Hi Quick question. I have a table that logs Cost-per-Click data, including the ID of the Affiliate that will be paid that CPC. I want to create a 'report' SQL SP that shows all the CPCs for a particular Affiliate for say the last week grouped by day,..
select statement with no results is producing locks - If I have a select statement that produces no results, what sort of locks could it still potentially generate? |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
