how to retrive only second row from table in sql server
2000?
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between sdf and mdf?
How can we determine what objects a user-defined function depends upon?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
how will add additional conditions in sql?
Explain throw statement in sql server 2008?
What are the new features in sql server 2016?
What is the Control Flow in SSIS
Tell me what is use of except clause? How it differs from not in clause?
What is the full meaning of dml?
How to enter unicode character string literals in ms sql server?
What happens when unicode strings concatenate with non-unicode strings?
How to replace null values in expressions using isnull()?
Explain what is analysis service repository?
What do mean by xml datatype?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?