I have a column number 1,2,3,4,.............................................600. I am using here
SELECT 1,2,3,4,5 FROM tbl;
here i get only the column no with data consisting of 1, 2, 3, 4,5 ....
My question is how I get from 1 to 16.
After i need the data from 18 to 59
and continue
i want to group...
please tell me what syntax will i use?
Lubomir Celar
Hi Hirak!
You can try this:
SELECT *
FROM table
WHERE (ID BETWEEN '1' AND '16')
OR (ID BETWEEN '18' AND '59')
OR (ID BETWEEN '100' AND '110')
;
1 votes
0 thanks
Chantal Austin
For Oracle databases, here is the answer :
SELECT COUNT (column_NAME)
FROM all_tab_columns
WHERE table_name = 'YOUR_TABLE_NAME'
;
;-)
0 votes
0 thanks
- Badges
- Science topic
- Similar topics
- Geoscience
- Asia
- India
More Hirak Mazumdar's questions See All
Similar questions and discussions