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
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