Find max value in Excel

Cell B1=MAX(A:A)

Clone table in SQL Server

SELECT *
INTO MyNewTable
FROM MyTable