Highest and lowest values
in [Programming SQL]
|
From: sameer on 7 Jul 2008 07:29 Hi, MY input values Low Value: A value(MIDDLE VALUE) to which RIGHT SIDE and LEFTSIDE values are should be HIGH. High Value: A value(MIDDLE VALUE) to which RIGHT SIDE and LEFTSIDE values are should be LOW. create table temp(time datetime,[close] money) insert into temp values('11:20','4006.00') insert into temp values('11:21','4007.20') insert into temp values('11:22','4008.00') insert into temp values('11:23','4009.70') insert into temp values('11:24','4010.00') insert into temp values('11:25','4011.50') insert into temp values('11:26','4012.80') insert into temp values('11:27','4013.00') insert into temp values('11:28','4012.00') insert into temp values('11:29','4011.90') insert into temp values('11:30','4012.80') insert into temp values('11:31','4013.60') insert into temp values('11:32','4014.20') insert into temp values('11:33','4013.00') insert into temp values('11:34','4012.40') insert into temp values('11:35','4014.20') insert into temp values('11:36','4015.60') insert into temp values('11:37','4017.40') insert into temp values('11:38','4018.50') insert into temp values('11:39','4019.00') insert into temp values('11:40','4020.50')----------high-- insert into temp values('11:41','4018.00') insert into temp values('11:42','4017.70') insert into temp values('11:43','4016.80') insert into temp values('11:44','4017.50') insert into temp values('11:45','4018.40') insert into temp values('11:46','4016.00') insert into temp values('11:47','4015.60') insert into temp values('11:48','4014.00') insert into temp values('11:49','4013.30') insert into temp values('11:50','4012.60') insert into temp values('11:51','4011.40') insert into temp values('11:52','4010.19')------low--- insert into temp values('11:53','4011.60') insert into temp values('11:54','4013.50') insert into temp values('11:55','4014.40') insert into temp values('11:56','4015.00') insert into temp values('11:57','4017.80') insert into temp values('11:58','4018.00') insert into temp values('11:59','4019.40') insert into temp values('12:00','4018.10') insert into temp values('12:01','4017.30') insert into temp values('12:02','4019.00') insert into temp values('12:03','4021.50') insert into temp values('12:04','4025.00') insert into temp values('12:05','4027.70') insert into temp values('12:06','4029.80') insert into temp values('12:07','4031.00') insert into temp values('12:08','4032.20') insert into temp values('12:09','4033.00')----high--- insert into temp values('12:10','4032.00') insert into temp values('12:11','4031.00') insert into temp values('12:12','4030.00') insert into temp values('12:13','4030.50') insert into temp values('12:14','4031.80') insert into temp values('12:15','4032.00') insert into temp values('12:16','4031.00') insert into temp values('12:17','4029.00') insert into temp values('12:18','4027.00') insert into temp values('12:19','4025.00') insert into temp values('12:20','4024.00') insert into temp values('12:21','4022.00')----low--- insert into temp values('12:22','4023.00') insert into temp values('12:23','4024.80') insert into temp values('12:24','4024.10') insert into temp values('12:25','4023.50') insert into temp values('12:26','4022.00') insert into temp values('12:27','4023.00') insert into temp values('12:28','4024.50') insert into temp values('12:29','4025.00') insert into temp values('12:30','4027.00') insert into temp values('12:31','4028.00') insert into temp values('12:32','4029.00') insert into temp values('12:33','4031.00') insert into temp values('12:34','4033.00') insert into temp values('12:35','4035.00') insert into temp values('12:36','4037.00') insert into temp values('12:37','4039.00') insert into temp values('12:38','4042.00') out put table looks like: 11:40 4020.50 11:52 4010.19 12:09 4033.00 12:21 4022.00
From: dave ballantyne on 7 Jul 2008 07:32 Hi , Can you confirm what you actually need ? Is it the Highest and Lowest values in a chronolocial hour ? Dave sameer wrote: > Hi, > > MY input values > > Low Value: > > A value(MIDDLE VALUE) to which RIGHT SIDE and LEFTSIDE values are should be > HIGH. > > High Value: > > A value(MIDDLE VALUE) to which RIGHT SIDE and LEFTSIDE values are should be > LOW. > > > create table temp(time datetime,[close] money) > > > > insert into temp values('11:20','4006.00') > > insert into temp values('11:21','4007.20') > > insert into temp values('11:22','4008.00') > > insert into temp values('11:23','4009.70') > > insert into temp values('11:24','4010.00') > > insert into temp values('11:25','4011.50') > > insert into temp values('11:26','4012.80') > > insert into temp values('11:27','4013.00') > > insert into temp values('11:28','4012.00') > > insert into temp values('11:29','4011.90') > > insert into temp values('11:30','4012.80') > > insert into temp values('11:31','4013.60') > > insert into temp values('11:32','4014.20') > > insert into temp values('11:33','4013.00') > > insert into temp values('11:34','4012.40') > > insert into temp values('11:35','4014.20') > > insert into temp values('11:36','4015.60') > > insert into temp values('11:37','4017.40') > > insert into temp values('11:38','4018.50') > > insert into temp values('11:39','4019.00') > > insert into temp values('11:40','4020.50')----------high-- > > insert into temp values('11:41','4018.00') > > insert into temp values('11:42','4017.70') > > insert into temp values('11:43','4016.80') > > insert into temp values('11:44','4017.50') > > insert into temp values('11:45','4018.40') > > insert into temp values('11:46','4016.00') > > insert into temp values('11:47','4015.60') > > insert into temp values('11:48','4014.00') > > insert into temp values('11:49','4013.30') > > insert into temp values('11:50','4012.60') > > insert into temp values('11:51','4011.40') > > insert into temp values('11:52','4010.19')------low--- > > insert into temp values('11:53','4011.60') > > insert into temp values('11:54','4013.50') > > insert into temp values('11:55','4014.40') > > insert into temp values('11:56','4015.00') > > insert into temp values('11:57','4017.80') > > insert into temp values('11:58','4018.00') > > insert into temp values('11:59','4019.40') > > insert into temp values('12:00','4018.10') > > insert into temp values('12:01','4017.30') > > insert into temp values('12:02','4019.00') > > insert into temp values('12:03','4021.50') > > insert into temp values('12:04','4025.00') > > insert into temp values('12:05','4027.70') > > insert into temp values('12:06','4029.80') > > insert into temp values('12:07','4031.00') > > insert into temp values('12:08','4032.20') > > insert into temp values('12:09','4033.00')----high--- > > insert into temp values('12:10','4032.00') > > insert into temp values('12:11','4031.00') > > insert into temp values('12:12','4030.00') > > insert into temp values('12:13','4030.50') > > insert into temp values('12:14','4031.80') > > insert into temp values('12:15','4032.00') > > insert into temp values('12:16','4031.00') > > insert into temp values('12:17','4029.00') > > insert into temp values('12:18','4027.00') > > insert into temp values('12:19','4025.00') > > insert into temp values('12:20','4024.00') > > insert into temp values('12:21','4022.00')----low--- > > insert into temp values('12:22','4023.00') > > insert into temp values('12:23','4024.80') > > insert into temp values('12:24','4024.10') > > insert into temp values('12:25','4023.50') > > insert into temp values('12:26','4022.00') > > insert into temp values('12:27','4023.00') > > insert into temp values('12:28','4024.50') > > insert into temp values('12:29','4025.00') > > insert into temp values('12:30','4027.00') > > insert into temp values('12:31','4028.00') > > insert into temp values('12:32','4029.00') > > insert into temp values('12:33','4031.00') > > insert into temp values('12:34','4033.00') > > insert into temp values('12:35','4035.00') > > insert into temp values('12:36','4037.00') > > insert into temp values('12:37','4039.00') > > insert into temp values('12:38','4042.00') > > > > > > > > > > out put table looks like: > > > > 11:40 4020.50 > > 11:52 4010.19 > > 12:09 4033.00 > > 12:21 4022.00 >
From: sameer on 7 Jul 2008 08:15 Hi, In that i am traying to draw a LINE with the help of HIGHEST points. i am trying to findout two high points. see this image how can i draw this line with TOP high values. http://www.tradersedgeindia.com/images/trendline3.gif
From: sameer on 7 Jul 2008 08:17 Hi, I am trying to find out TWO highest points with help of this data. see this image and How to draw a LINE with top HIGHS. http://www.tradersedgeindia.com/images/trendline3.gif
From: sameer on 7 Jul 2008 08:17
Hi, I am trying to find out TWO highest points with help of this data. see this image and How to draw a LINE with top HIGHS. http://www.tradersedgeindia.com/images/trendline3.gif |