how to retrive only second row from table in sql server
2000?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / suresh
Hi,
select top 1 * from (SELECT TOP 2 * from emp) A Order by
empno desc
Is This Answer Correct ? | 16 Yes | 9 No |
Answer / yogesh
select top 1 from tablename where id <(select top 1 id from
test)
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / arun kumar k s
drop table #temp select top 2 identity(int,1,1) as SlNo, *
into #temp from TABLE_NAME select * from #temp where SlNo=2
Is This Answer Correct ? | 7 Yes | 5 No |
Answer / 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 |
Answer / shashikant
select min(id) from cms_dfm where id in (SELECT TOP 2 ID
from CMS_DFM Order by
ID desc)
Is This Answer Correct ? | 6 Yes | 4 No |
Answer / belson gnana pradeep
SELECT TOP 1 salary FROM
(SELECT DISTINCT TOP 2 salary FROM employee
ORDER BY salary DESC) a ORDER BY salary
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / vardharaj
SELECT TOP 1 ID FROM TABLENAME WHERE ID NOT IN (SELECT TOP 1
ID FROM TEST)
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / surenda tarai
select top 1 * from(select top 3 * from tablename order by 1
asc) as at order by 1 desc
Is This Answer Correct ? | 1 Yes | 0 No |
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
State the difference between local and global temporary tables?
What is the datatype of rowid?
What is the difference between varchar and varchar types?
Define outer join?
What is the difference between for trigger and after trigger?
Explain what is meant by replication of database?
What is a cursor, index in sql?
What is the difference between insensitive and scroll cursor?
How to create an multi-statement table-valued function?
What are partitioned views and distributed partitioned views?
Define left outer join in sql server joins?