Become a fan of Slashdot on Facebook

 


Forgot your password?
Close
typodupeerror
×

Comment Re:Simple (Score 1) 1067

I think of it as a relational database,

SELECT A.HammerSales / B.HardwareSales AS Answer
FROM
    (
        SELECT Sum(Amount) AS HammerSales
        FROM SALES
        HAVING Item='Hammer' And MonthOfSale='201505'
    ) A ,
    (
        SELECT Sum(Amount) AS HardwareSales
        FROM SALES
        HAVING Department='Hardware' And MonthOfSale='201505'
    ) B

It will not return zero if there are no sales at all for last month. It will return an empty dataset (i.e. no data).

Submission + - Russian troops traced to Ukrainian battlefields through social media

Submitted by wienerschnizzel
wienerschnizzel writes: Vice News released a report on how they were able to trace a member of the regular russian army from his base near the Ukriainian border towards the battlefields in the contested territory in eastern Ukraine and back to his home in Siberia using the pictures he uploaded on his social media profile.

The methodology used is based on a report by the Atlantic Council think tank released earlier this year, that asserts that information on the movement and operations of the regular russian troops can be easily gathered from publicly available sources (such as the social media).

The russian government still denies any involvement of russian troops in the fights in Ukraine.

Submission + - China plans to land on the far side of the moon by 2020 (examiner.com)

Submitted by Anonymous Coward
An anonymous reader writes: According to a story in Quartz, the Chinese have decided to land the Chang’e 4 probe on the far side of the moon. Chang’e 4 is a backup probe to the Chang’e 3, which landed on the lunar surface in December 2013 and carried a rover called Yutu. Because the spacecraft will have to be reconfigured, its scheduled launch will be delayed until sometime before 2020, likely after the Chang’e 5 sample return mission which is currently scheduled to launch in 2017.

Submission + - Why there needs to be a quantum theory of gravity

Submitted by StartsWithABang
StartsWithABang writes: If you’re not a theoretical physicist yourself, you might think that physics is physics — we ask questions about the Universe, do experiments/make observations, and get the answers — and math is just a tool that we use to help us get there. But that really sells the power of mathematics short. For a physical theory to be valid, there are a whole host of mathematical properties that theory needs to possess, including being free of logical inconsistencies, making predictions about observables, and that those predictions agree with observations. Yet when we look at our theory of gravitation at the smallest scales and with the strongest gravitational fields, our theory itself fails, which is precisely why we need a quantum theory of gravity.

Comment Re: Good (Score 1) 302

by Alien1024 (#49628251) Attached to: Uber Forced Out of Kansas
In all fairness to PayPal, of course it's not a bank. They don't lend money, they don't engage in fractional-reserve banking and money creation. That's one of the fundamental roles of a bank. (just because it can do transfers and deposits doesn't mean it's a bank)

Submission + - European Commision Will Increase Use of Open Source Software (europa.eu)

Submitted by jrepin
jrepin writes: The European Commission has updated its strategy for internal use of Open Source Software. The Commission, which is already using open source for many of its key ICT services and software solutions, will further increase the role of this type of software internally. The renewed strategy puts a special emphasis on procurement, contribution to open source software projects and providing more of the software developed within the Commission as open source.

Submission + - Spain judge blocks access to The Pirate Bay (torrentfreak.com)

Submitted by TuringTest
TuringTest writes: A Spanish judge has ordered ISPs to block domains belonging to the Swedish site. The ruling comes after Spanish private Association for Digital Rights Management sued Neij Holdings LMT two years ago.

Slashdot Top Deals

Always draw your curves, then plot your reading.

Close