Saturday 14 September 2013

SQL First()

SQL First():-First() function is only present in the MS Access .
in MS Access we simply use the first() for getting the first row
but in sql server we write..

table:-

here we give top keyword .if we write top 2 it will show fist two row.
we write top 1 id which shows the id present in first .


for selecting the whole row we will write

                                                   select top 1 * from item;

No comments :

Post a Comment