[untitled]
1 pointsby ycom13__0 comments
In the Heart of the Sea: The Tragedy of the Whaleship Essex by Nathaniel Philbrick
Elon Musk: Tesla, SpaceX, and the Quest for a Fantastic Future by Ashlee Vance
To the Last Man: A Novel of the First World War by Jeff Shaara
Dead Wake: The Last Crossing of the Lusitania by Erik Larson
The Wright Brothers by David McCullough
All 21 books I read are here https://news.ycombinator.com/item?id=10785428 A Dance with Dragons (A Song of Ice and Fire) by George R. R. Martin
A Feast for Crows: A Song of Ice and Fire (Game of Thrones) by George R.R. Martin
The Confident Speaker: Beat Your Nerves and Communicate at Your Best in Any Situation by Harrison Monarth
House of Leaves by Mark Z. Danielewsk
To the Last Man: A Novel of the First World War by Jeff Shaara
Dead Wake: The Last Crossing of the Lusitania by Erik Larson
Becoming Steve Jobs: The Evolution of a Reckless Upstart into a Visionary Leader by Brent Schlender
George Washington's Secret Six: The Spy Ring That Saved the American Revolution by Brian Kilmeade
Think Like a Freak: The Authors of Freakonomics Offer to Retrain Your Brain by Steven D. Levitt
Elon Musk: Tesla, SpaceX, and the Quest for a Fantastic Future by Ashlee Vance
Finders Keepers: A Novel by Stephen King
The Guns of August: The Pulitzer Prize-Winning Classic About the Outbreak of World War I by Barbara W. Tuchman
The Wright Brothers by David McCullough
Seveneves: A Novel by Neal Stephenson
The Devil in the White City: Murder, Magic, and Madness at the Fair That Changed America by Erik Larson
Hitler's Last Day: Minute by Minute by Emma Craigie
The Girl on the Train by Paula Hawkins
Robopocalypse: A Novel (Vintage Contemporaries) by Daniel H. Wilson
Robogenesis by Daniel H. Wilson
In the Heart of the Sea: The Tragedy of the Whaleship Essex by Nathaniel Philbrick
My 5 favorite ones from that list are In the Heart of the Sea: The Tragedy of the Whaleship Essex by Nathaniel Philbrick
Elon Musk: Tesla, SpaceX, and the Quest for a Fantastic Future by Ashlee Vance
To the Last Man: A Novel of the First World War by Jeff Shaara
Dead Wake: The Last Crossing of the Lusitania by Erik Larson
The Wright Brothers by David McCullough ;WITH cte AS(SELECT
ROW_NUMBER() OVER(PARTITION BY SomeVal
ORDER BY SomeDate DESC) AS row,
* FROM SomeTable)
UPDATE cte
SET id = CASE WHEN row = 1 THEN 1 ELSE 0 END
Here is the DDL and DML in case you want to play around with this CREATE TABLE SomeTable(id int,SomeVal char(1),SomeDate date)
INSERT SomeTable
SELECT null,'A','20110101'
UNION ALL
SELECT null,'A','20100101'
UNION ALL
SELECT null,'A','20090101'
UNION ALL
SELECT null,'B','20110101'
UNION ALL
SELECT null,'B','20100101'
UNION ALL
SELECT null,'C','20110101'
UNION ALL
SELECT null,'C','20100101'
UNION ALL
SELECT null,'C','20090101'