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

List the different types of collation sensitivities in sql server?

0 Answers  

what is denormalization and when would you go for it? : Sql server database administration

0 Answers  

What is sql profiler. What are the default templates with it? : sql server database administration

0 Answers  

There is a table1 with records (1,2,3,4,5,6) and table2 with records (4,5,6,7,8,9).write a query so as to get the result as 1,2,3,4,5,6,7,8,9

12 Answers   RBS,

What is the maximum size of a row in sql server?

0 Answers  

What are primary keys and foreign keys?

4 Answers  

I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 Answers  

What are group functions in query statements in ms sql server?

0 Answers  

Can store procedure call by user define function in SQL server?

10 Answers   HCL,

What is the difference between constraints and triggers?

9 Answers   Wipro,

What are the steps you can take to avoid “deadlocks”?

0 Answers  

What are the main control-of-flow T-SQL constructs?

1 Answers