How to select a particular Row in SQL Server

stellusm...

SOLVED CLOSED ACTIVE ANSWERED
User: stellusmca
Posted: on Dec 01, 2012 06:21 AM
Forum: SQL Server
Answer: 1
Views: 2558

Hi all,

i have some specific douts regarding SQL SERVER , that is i have one table which is employee were as empname and empsalary are the fields of employee table.Please find the below table,

empname empsalary

A 100

B 200

C 300

D 400

in the above table i just want to select and display row 1,row2 and row4. I tryied so many ways but am getting errors, please provide me a exact query or give me a comments.

thanks in advance.

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 1

Reply
ANSWER
User: Mudassar
Replied: on Dec 01, 2012 06:25 AM
Report

You can make use of Row_Number property

declare @Emp table(Name varchar(10), salary int)

insert into @Emp
select 'A', 100
union all
select 'B', 200
union all
select 'C', 300
union all
select 'D', 400

select * from
(
select  ROW_NUMBER() OVER
      (
            ORDER BY Name ASC
      )AS RowNumber, 
	  * from @Emp
	  ) as tbl
	  where RowNumber in (1, 2,  4)

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

How to select a particular Row in SQL Server

Company

Explore

Follow us

Contact Us