Printable View
Hi All
Can any one let me know how can i get range of a particular column from database
Eg:
if i have a below table in data base
id Name
---------------------------
1 Item1
2 Item2
5 Item5
6 Item6
7 Item7
9 Item9
11 Item11
---------------------------
i want to get out put like below one
id
------------------
1-2
5-7
9
11
------------------
I have heard it is possible but not sure how to do can any one please help me.
And what does thismean?Quote:
Originally Posted by nmkishan22
Or:confused:Quote:
Originally Posted by nmkishan22
Is it a simple subtraction or what?
its not minus it is the range of the ID present in the table
ex. 1 to 2 are present in table
5 to 7 are present in table
9 is present in table
11 is present in table
so tht i can populate a combobox with different ids present in table else i need to get each item from table which wil be overload. If i have range i can manipulate in my application and get all the ids from the range i retrieved from table.
Unfortunately your explanation didn't make your "problem" more clear for me.
What are you going to populate in a combobox: IDs or Names?
What is wrong just to SELECT ID FROM [your table]?
If below is my table with 2 column id and Name
id Name
---- ----------------------
1 Item1
2 Item2
5 Item5
6 Item6
7 Item7
9 Item9
11 Item11
---- -----------------------
if i write "Select Id from table" i wil get O/P like below
id
---
1
2
5
6
7
9
11
----
But i wanted to get o/p like
id
------------------
1-2
5-7
9
11
------------------
Please help me out...
I think that SELECT ID FROM [your table]
+ write 5-7 line of code to find all the cases where the next record ID is not equal (the previous one + 1) would be much faster than waiting for answers how to do it only by means of SQL.
can you please give the code to do so. My id field will take value from 0 - 9999999999 so looping wil be a problem for me
No, I won't just try!
It will be a very simple exercise for you to write such a code. Then you should test how fast/slow will it work with your very big table. If too slow - then and only then you should try to improve it.
try this
SELECT * FROM tableName WHERE id IN (1,2,5,8)
!. Do you expect OP is still needing our help? The thread is 15 months old! :rolleyes:Quote:
Originally Posted by bex_zex
2. How your query could help the OP to get the following output:confused:Quote:
Originally Posted by nmkishan22