| Author |
Topic |
|
sagavb
Starting Member
18 Posts |
 Posted - 2009-06-01 : 00:31:54
|
Hi there,
Is it possible to get top 2 record from below table
Table name: test
name sal
Mr.X 800
Mr.Y 1000
Mr.Z 1500
Mr.A 2000
Expected output should be as
name sal
Mr.Y 1000
Thanks in advance
Saga  |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-06-01 : 01:07:18
|
Saga sir,
do u have any identity column or primary key?
Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-06-01 : 01:15:26
|
http://sqlblogcasts.com/blogs/madhivanan/archive/2008/09/12/return-top-n-rows.aspx
KH
[spoiler]Time is always against us[/spoiler]
|
|
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-06-01 : 01:23:22
|
Try this!
select top 1 from
(select top 2 * from test order by sal) t order by sal desc
Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled |
|
|
|
sagavb
Starting Member
18 Posts |
Posted - 2009-06-01 : 01:36:48
|
Senthil Sir,
I dont think it will work.
Can you copy that query and run it?
Regards
Saga
quote:
Originally posted by senthil_nagore
Try this!
select top 1 from
(select top 2 * from test order by sal) t order by sal desc
Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled
|
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-06-01 : 01:37:55
|
quote:
Originally posted by senthil_nagore
Try this!
select top 1 * from
(select top 2 * from test order by sal) t order by sal desc
Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled
KH
[spoiler]Time is always against us[/spoiler]
|
|
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-06-01 : 01:40:22
|
saga sir,
just i miss the "*" as khtan pointed out... u must debug it saga...
else ask ur boss...
Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled |
|
|
|
sagavb
Starting Member
18 Posts |
Posted - 2009-06-01 : 01:53:13
|
Hey Thanks la
quote:
Originally posted by senthil_nagore
saga sir,
just i miss the "*" as khtan pointed out... u must debug it saga...
else ask ur boss...
Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled
|
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-06-01 : 02:38:00
|
quote:
Originally posted by sagavb
Hi there,
Is it possible to get top 2 record from below table
Table name: test
name sal
Mr.X 800
Mr.Y 1000
Mr.Z 1500
Mr.A 2000
Expected output should be as
name sal
Mr.Y 1000
Thanks in advance
Saga
Your expected output contradicts your topic "Selecting Top 2 record"
What basis do you want to get it?
Madhivanan
Failing to plan is Planning to fail |
|
|
|
sagavb
Starting Member
18 Posts |
Posted - 2009-06-01 : 02:45:21
|
Hi Madhivanan,
I meant, selecting 2nd record from a table
Regards
Saga
quote:
Originally posted by madhivanan
quote:
Originally posted by sagavb
Hi there,
Is it possible to get top 2 record from below table
Table name: test
name sal
Mr.X 800
Mr.Y 1000
Mr.Z 1500
Mr.A 2000
Expected output should be as
name sal
Mr.Y 1000
Thanks in advance
Saga
Your expected output contradicts your topic "Selecting Top 2 record"
What basis do you want to get it?
Madhivanan
Failing to plan is Planning to fail
|
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-06-01 : 04:30:18
|
What basis do you need second record?
Madhivanan
Failing to plan is Planning to fail |
|
|
|
|
Selecting Top 2 record