Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrive only second row from table in sql server
2000?
- 15 Answers
- 26694 Views
- Cognizant, CTS, I also Faced
- E-Mail Answers
Answer Posted / ravi148
hi,
dileep is exactly correct , arun .. iam sorry to say ur
wrong
suppose for employee table, write as
DECLARE curTemp SCROLL CURSOR FOR
SELECT TOP 2 * from EMPLOYEE
OPEN curTemp
FETCH LAST FROM curTemp
CLOSE curTemp
DEALLOCATE curTemp
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is compound operators?
Describe the functionalities that views support.
What are the triggers in sql?
Which are the new data types introduced in sql server 2008?
What are the system database in sql server 2008?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
How to send email from database?
What are the dis_advantages of stored procedures, triggers, indexes?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
How many types of functions are there in sql server?
What is query optimization process?
Explain how dts is used to extract, transform and consolidate data?
Explain what is log shipping?
How to create a simple stored procedure in ms sql server?
Can you explain what is sql server english query?
