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

Can I work with several databases simultaneously? : sql server management studio

0 Answers  

can we call stored Procedure in Function in Sql Server 2000 and vice versa.

3 Answers   C3I, eSoft, iPRO Solutions, Wipro,

How does normalization work?

0 Answers  

What is a rollup clause?

0 Answers  

What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,

what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

What is store procedure?

0 Answers  

What is an index. What are the types?

0 Answers  

Can we call SP inside a query?

5 Answers   CA, CarrizalSoft Technologies, Wipro,

Explain what are the restrictions that views have to follow? : SQL Server Architecture

0 Answers  

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

What is dbcc? Give few examples.

0 Answers