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 |
how many triggers you can have on a table? : Sql server database administration
what are candidate key, alternate key and composite key? : Sql server database administration
How do I find information about the install locations for the various instances running on a computer?
How can you get @@error and @@rowcount at the same time?
system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??
List few advantages of stored procedure.
Delete duplicate records from the table?(Table must have unique id)
7 Answers TCS, Thomson Reuters,
What is the cartesian product of table?
sql server architecture ?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
What the different components of Replication and what is their use?
Explain the dbcc pintable command when would you use it?