Competing Data

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
  

Poston Tue, 10 Jan 2006 10:24 am

Hello, I have a doubt I'm looking for for days, and I can't find a solution, neither in Google nor in forums.
I have a table that has connections with start time and end time, need to get the total number of links competitors namely, do a sweep searching for the final dates less than or equal to the initial dates of other connections.
Example a link starts the 10:00 and ends the 10:05, other link starts the 10:03 and ends the 10:10, are marked 2 competing links, due to they occupy the same space of time simultaneously.

How can I do???
Thank You Cesar Duarte
cduarte
Location: São Caetano do Sul - SP

[]s
Cesar

Poston Tue, 10 Jan 2006 1:35 pm

Cesar, please send the create table and a few sample records so that the forum can play. If possible, send also the result that you expect from query.
mportes
Location: São Paulo




Return to PL/SQL

Who is online

Users browsing this forum: No registered users and 2 guests