Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrive only second row from table in sql server
2000?
- 15 Answers
- 26656 Views
- Cognizant, CTS, I also Faced
- E-Mail Answers
Answer Posted / dileep.t
----------------------------------
:), This will also work, without additional columns in
result
---------------------------------
DECLARE curTemp SCROLL CURSOR FOR
SELECT TOP 2 * from <TABLE_NAME>
OPEN curTemp
FETCH LAST FROM curTemp
CLOSE curTemp
DEALLOCATE curTemp
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
Define Joins?
What are the encryption mechanisms in sql server?
When you should use a low fill factor?
Where actually sql azure database is hosted?
Comment,Datatypes are unlimited
What does truncate do?
How to change a login name in ms sql server?
How to list all user names in a database?
How do I start sql server 2017?
List out what other servers you can use with ssrs?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
Why we use trigger in sql server with example?
What is the filtered index?
What new changes are being made in SQL Server?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
