Select only first row from database

If we want to select first row from database without using where clause.

Following code can be used.

select top 1 * from table_name

To select top 2 rows

select top 2 * from table_name



Summary

In this article I try to expose Database trick. I hope after reading this article you will be able to use this trick in your code. I would like to have feedback from my blog readers. Please post your feedback, question, or comments about this article.