MS SQL Server provides the top syntax that can be used in SQL select queries to limit the records returned from a query. This is especially useful when querying very large tables in cases where the user only cares about a subset of the records. Listed below are examples of how to use the top syntax.
The Spahn Ranch in Chatsworth, California was the base of operations used by Charles Manson and his followers during their 1969 murder spree. The Manson Family case can be regarded as a metaphor for the end of innocence of the decade of peace and love.
The Arrest. Ironically, Manson and his Family were arrested not on suspicion of the murders but simply on the belief that they had vandalised a portion of the Death Valley National Park while they were hiding out in the Mojave Desert. In 1969, the local county sheriff had them in custody not realising that he had murder suspects on their hands.