I want to display 5th record in the first row How? in SQL

Ya if two partia class have a same method name with same signature...it ll show an error "multiple defination found", but if signature are different then it will considered as overloaded method.

Himanshu Manjarawala
Sr. Software Engineer@AutomationAnywhere
http://fieredotnet.wordpress.com/

Gg, if this helps please login to Mark As Answer. | Alert Moderator

IN case of partial classes and methods..if signature are different then it will allowed and if signature are same then it will not allowed two partial definations.

below is the SQL which will help you to return 5 record at the top and other records at the bottom.

employee table structure

Column_name Type
ID int
EmpNumber varchar
Status varchar
Manager varchar
EmpType varchar

SQL to execute

with employeetemp
as
(select ID, EmpNumber, Status, Manager, EmpType, ROW_NUMBER() OVER (ORDER BY ID) as RowNumber from employee
)
select ID, EmpNumber, Status, Manager, EmpType from employeetemp
where RowNumber>=5
union all
select top 4 ID, EmpNumber, Status, Manager, EmpType from employeetemp

Gg, if this helps please login to Mark As Answer. | Alert Moderator

Hi,
For ur second Question
Try Like This..

SELECT name,sal FROM emp e1 Where n=(select Count(distinct(sal)) From emp e2 

WHERE e2.sal>=e1.sal)

This Query can be used to find the nth max salary the number with the where clause should be n-1 .
For more on Sql Queries..
http://sqlservercodebook.blogspot.com/2008/03/find-3rd-max-salary.html

Thanks & Regards,

Gg, if this helps please login to Mark As Answer. | Alert Moderator