[ Date Index ]
[ Thread Index ]
[ <= Previous by date /
thread ]
[ Next by date /
thread => ]
Re: [LUG] SQL query help please
- To: list@xxxxxxxxxxxxx
- Subject: Re: [LUG] SQL query help please
- From: stinga <stinga+dcglug@xxxxxxxxxxxxx>
- Date: Fri, 11 Sep 2020 19:16:21 +0800
- Content-language: en-US
- Delivered-to: dclug@xxxxxxxxxxxxxxxxxxxxx
- Dkim-signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=dcglug.org.uk; s=1586423162; h=Sender:Content-Type:Reply-To:List-Subscribe: List-Help:List-Post:List-Unsubscribe:List-Id:Subject:In-Reply-To:MIME-Version :Date:Message-ID:From:References:To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:Resent-Date:Resent-From:Resent-Sender:Resent-To:Resent-Cc :Resent-Message-ID:List-Owner:List-Archive; bh=ezg8J9lCyLCy6U5pweH2DFi9/UuJnssh906IU/gNjlA=; b=1EzausVlo+Nk29lLUp4qbEHg5V xz0YiOeRoSz9YNwWX/8iknVEsSMh7FWtkxXxUmP96KctJfGBzuqgSawMoxs1QAJ+zbzLr7oykl5rm qRpMSzQ/acjfG3BCHPy8fa6FEEVDQbbNlFfn9BGtxoWAnDOlz3YKbg5EoUKPvUwaU8uA=;
On 11/09/2020 19:10, Sebastian wrote:
SELECT COUNT(*) FROM earthquake WHERE cause = 'earthquake';
SELECT occured_on, magnitude, place, cause FROM earthquakes ORDER BY magnitude DESC LIMIT 3;
table earthquake <> earthquakes :-)
--
'ooroo
Stinga...(:)-)
---------------------------------------------------
Email: stinga+dclug@xxxxxxxxxxxxx o
You need only two tools. o /////
A hammer and duct tape. If it /@ `\ /) ~
doesn't move and it should use > (O) X< ~ Fish!!
the hammer. If it moves and `\___/' \) ~
shouldn't, use the tape. \\\
---------------------------------------------------
--
The Mailing List for the Devon & Cornwall LUG
https://mailman.dcglug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/listfaq