Select * (-----)

Question

Post reply

Select * (-----)

fri

Old Hand

Points: 339
More actions
August 18, 2022 at 8:47 am
Go to Answer
#4077815
thank you all!!!
- This topic was modified 2 years, 3 months ago by fri.
- This topic was modified 2 years, 3 months ago by fri.

Jonathan AC Roberts

SSCoach

Points: 18354

August 18, 2022 at 10:37 pm

Answer

#4078145

Here you go, this is an answer for your homework lol:

select t1.station_name, count(distinct t2.station_name) reachable_stations
  from train_st t1
  left join train_st t2
         on t2.code = t1.code
        and t2.stop_number > t1.stop_number
        and datediff(mi, t1.departure, t2.arrival) <= 60
 group by t1.station_name
 order by 2 desc, 1;

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Mike01 SSChampion Points: 11395 More actions · Answer 1

DDL, Sample Data and expected results will help us help you

For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

drew.allen SSC Guru Points: 76985 More actions · Answer 2

Also, don't cross post. You now have four separate threads with the same question.

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

ratbak Ten Centuries Points: 1358 More actions · Answer 3

ratbak

Ten Centuries

Points: 1358

August 18, 2022 at 8:56 pm

#4078121

And probably homework.

fri Old Hand Points: 339 More actions · Answer 4

fri

Old Hand

Points: 339

August 18, 2022 at 10:44 pm

#4078148

Thank you so much

Jonathan AC Roberts SSCoach Points: 18354 More actions · Answer 5

Now has got the answer he wanted he's deleted the evidence. 🤣

fri Old Hand Points: 339 More actions · Answer 6

Do you think it's not a good thing? and how do you think like it's a HW work(it's not a HW but I would say type of that). anyhow thank you so much.

Jonathan AC Roberts SSCoach Points: 18354 More actions · Answer 7

fri wrote:

Do you think it's not a good thing? and how do you think like it's a HW work(it's not a HW but I would say type of that). anyhow thank you so much.

I just wondered why you deleted the contents of the question?

Jeff Moden SSC Guru Points: 1004324 More actions · Answer 8

Jonathan AC Roberts wrote:

Now has got the answer he wanted he's deleted the evidence. 🤣

Now you know why I frequently quote the original post. He also deleted the post on his other threads. At least he's complete about being a jerk. 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)