Changes

Venture Capital (Data) (view source)

474 bytes added , 18:26, 26 June 2017

insurance company focused on renters insurances';

--1

==Removing duplicates from ipos table==

If you create the following two tables you'll notice that there are duplicate entries in the ipos table.

DROP TABLE ipospkey;

CREATE TABLE ipospkey AS

SELECT *,

concat(issuer::text, issuedate::text, statecode::text, principalamt::text) AS pkey

FROM ipos;

--10440

DROP TABLE iposcount;

CREATE TABLE iposcount AS

SELECT issuer, issuedate, statecode, COUNT(pkey)

FROM ipospkey

GROUP BY issuer, issuedate, statecode;

--9491

220

edits