SQL SERVER - Retrieve Last Entered Data
<p>I've searched for long time for getting last entered data in a table. But I got same answer.</p>

<pre><code>SELECT TOP 1 CustomerName FROM Customers
ORDER BY CustomerID DESC;
</code></pre>

<p>My scenario is, how to get last data if that Customers table is having <code>CustomerName</code> column only? No other columns such as <code>ID</code> or <code>createdDate</code> I entered four names in following order.</p>

<p>James<br>
Arun<br>
Suresh<br>
Bryen<br></p>

<p>Now I want to select last entered <code>CustomerName</code>, i.e., <code>Bryen</code>. How can I get it..?</p>