How to make a range of numbers in SQL

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Mon, 03 Oct 2005 2:34 pm

How to make a Select generating a table of track Ex: all products from 01 to 10 generate a line of range 1 every 10 to 20 products generate a faixa2 line .... ex: How do I need to Select (0.10) range 1, (10.20) faixa2 from dual Thanks I have Oracle 10 g band.
joliveira
Location: sp

Poston Mon, 03 Oct 2005 3:04 pm

I do not quite understand what you want.
You want to group by tracks and get the amount?

Show how you want the reply of your select you guys ...
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered

Poston Fri, 25 Nov 2005 4:15 pm

Have you ever thought of a create a table the part to indicate which products are in each track???
For example: select t. numeroproduto, t. track from Table1 t1, tabela_de_faixas t where t1. numeroproduto = t. numeroproduto and if you have to bring in a single line the tracks use the group by ...
cigano
Location: Pindamonhangaba - SP



Return to SQL

Who is online

Users browsing this forum: No registered users and 7 guests