Category: .NET

09 Dec 2016 17:50

Joined:	29/05/2009
Level:	Gold
Points:	10380

Points:	5

How to Get Top values for this Query

Hi

Create Table TestDemo
(
ID int,
amount decimal(6,2)
)

Insert into TestDemo values(10,1500)
Insert into TestDemo values(9,1000)
Insert into TestDemo values(9,NULL)
Insert into TestDemo values(8,50)
Insert into TestDemo values(7,30)
Insert into TestDemo values(6,10)

select * from TestDemo

-- I need how to get top 2 records only 2 separate variable in sql server
--like this

-- in my sql server declare value this

---Declare @TOP1 int ,@Top2 int
--I need set value here
-- set @TOP1=1500 -- for id = 10
-- set @TOP2=1000 --- for id = 9 is not null
-- How will do this

#768510

09 Dec 2016 18:52

Joined:	18/12/2008
Level:	Gold
Points:	2921

Points:	2

Hi,

You want only first two values is that what you mean?


Select Top 2 Amount From TestDemo ORDER BY ID DESC

If this is not you expecting. Kindly give some nice examples.

Thanks,
Mani

#768516

10 Dec 2016 06:40

Joined:	30/04/2012
Level:	Gold
Points:	7233

Points:	3

You can use given code snippet for Get Top values from any table

SELECT TOP 1 emp.name, emp.salary from ( SELECT TOP N emp.name, emp.salary
    FROM emp
    ORDER BY emp.salary DESC )

Where
Emp is table name
Salary and name is field of table
And Nth gives top values from your table

Reference:
http://stackoverflow.com/questions/26354221/sql-how-to-select-max-5-values-from-table

How to Get Top values for this Query

About dotnetspider.com

Quick Links

General

Services