Answer / lekhraj

select top 1 * from(select top 2 * from tbl_test order by 1
asc) as at order by 1 desc

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

Answer / suresh

Hi,

select top 1 * from (SELECT TOP 2 * from emp) A Order by
empno desc

Answer / yogesh

select top 1 from tablename where id <(select top 1 id from
test)

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

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

Answer / shashikant

select min(id) from cms_dfm where id in (SELECT TOP 2 ID
from CMS_DFM Order by
ID desc)

Answer / belson gnana pradeep

SELECT TOP 1 salary FROM
(SELECT DISTINCT TOP 2 salary FROM employee
ORDER BY salary DESC) a ORDER BY salary

Answer / vardharaj

SELECT TOP 1 ID FROM TABLENAME WHERE ID NOT IN (SELECT TOP 1
ID FROM TEST)

Answer / surenda tarai

select top 1 * from(select top 3 * from tablename order by 1
asc) as at order by 1 desc

Is Sql non procedural query language?

1 Answers   Verifone,

How to fetch the next row from a cursor with a "fetch" statement?

0 Answers  

What is blocking and how would you troubleshoot it?

2 Answers  

how to get 25th row in any table in sqlserver can u tell me syntax

8 Answers  

Hi, I have a table A which has four rows as follows Table A ------- empname salary ------- ------ A 1000 B 2000 C 3000 A 1000 B 2000 D 5000 I need the following output: empname salary ------- ------ A 1000 A 1000 B 2000 B 2000 Thanks in advance

10 Answers   IBM,

What is wrong with sql server client libarary dll, ntwdblib.dll?

0 Answers  

What are the differences between having and where clause.

0 Answers  

In what three ways is the return statement used in a stored procedure?

0 Answers  

How to delete database objects with "drop" statements in ms sql server?

0 Answers  

How to list all stored procedures in the current database using ms sql server?

0 Answers  

What is local temp table?

0 Answers  

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

3 Answers   iFlex,