SQL query
-
Here is the data in my table.
noname
1 kfd
2 vnj
3ksdk
4jfdjs
2cjsa
2jsd
3ajfd
4hfsdakj
3gfds
5hcgs
6gcds
5fgshg
5vfhvdas
8dgg
8hfv
8jdhgj
4hbf
I wanted to get the rows for first 2 least nos(1,2) and then next least 2(3,4) and the next least two.like that i wnated to get the rows for the every two numbers.can anybody help me in this issue.
Thanks.
-
Do you want these as separate recordsets? Is that what you're looking to do? Or are you looking for them in a particular order as a single recordset?
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley -
I want them in seperate record sets.
Thanks.
-
I feel like I'm over simplifying these things, because someone usually follows up my code plops with a set-based solution.
If you want separate recordsets, though, would this (over-simplified and non-robust code) work for you?
CREATE TABLE#tblSort (
Numint,
Lettersvarchar(64))
/*
INSERT STUFF
*/
DECLARE@MinOfSetint,
@NextMinOfSetint,
@LastMinint,
@NextMinint,
@MaxOfTableint
SET @MinOfSet = 0 --Assuming a non-zero value for simplicity.
SELECT@MaxOfTable = Max(Num)
FROM#tblSort
SELECT@MinOfSet = Min(Num)
FROM#tblSort
WHILE @MinOfSet <= @MaxOfTable
BEGIN
SELECT@NextMinOfSet = Min(Num)
FROM#tblSort
WHERENum > @MinOfSet
SELECT*
FROM#tblSort
WHERENum IN (@MinOfSet,@NextMinOfSet)
ORDER BYNum, Letters
SELECT@MinOfSet = Min(Num)
FROM#tblSort
WHERENum > @NextMinOfSet
ENDHTH,
SJTerrill
DROP TABLE #tblSort
-
Ah, so that's where all those dratted smileys went.
SJTerrill
-
Try this:
DECLARE @n int
SET @n = (
SELECT min(no)
FROM test
)
WHILE @n is not null
BEGIN
SELECT * FROM test WHERE no = @n OR no = @n + 1
/** Choose: (wasn't sure which way you wanted it)
SET @n = (
SELECT min(no)
FROM test
WHERE no >(@n+1)
)
--OR--
SET @n = @n + 2
**/
END
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply