Search results for query: *

thank you guys it worked out pretty well regards harsha

what you have done is increased\decreased the values by 5% and not 0.5 that is the reason why there are 11 pairs and not 4.

Dear PHV, this code will not work as the 8 rows i gave are 4 twin pairs, both rows in a twin pair have almost similar values( here the difference is 0.5)for eg 02C09873 135.8 135.8 179 186.98 236.29 240.3 01C06059 135.68 135.68 178.77 186.71 236.09 240.23 leaving the...

all the columns except the first one harsha

the output should be like Column1 Col2 col3 col4 col5 col6 col7 02C09873 135.8 135.8 179 186.98 236.29 240.3 01C06059 135.68 135.68 178.77 186.71 236.09 240.23 02C10226 131.52 131.52 170.94 174.94 224.13 236.27 01C05669 131.43 131.43 170.88...

hi the input values are, Column1 Col2 col3 col4 col5 col6 col7 02C10226 131.52 131.52 170.94 174.94 224.13 236.27 01C07330 131.6 131.6 175.07 183.04 236.32 236.32 HI1330 131.59 131.59 170.94 174.95 220.25 248.44 01C05669 131.43 131.43 170.88 174.83 224.07 236.28...

Dear all, I have the following data col1 col2 col3 col4 a decimal value decimal value decimal value b decimal value decimal value decimal value c decimal value decimal value decimal value d decimal value decimal value decimal...

Dear All, I have a bunch of entries (numeric) in a database,each row is related to one other row( all the entries in that row differ by +- 0.5 from one other row in the database, somewhat like almost similar values with minor differences ) how do i write a SQL query to identify the...

Dear All, I am looking for a software which looks for a certain word in a text paragraph and links it to a given page for all the occurrences in the page. for eg if a paragraph has 10 occurences of a word say 'index' all the occurrences should be linked dynamically instead of us...

Hi, How do i add a '-' (hyphen) at a particular position in a given string for eg the string is 'perl' how do i convert it to 'pe-rl' thanks in advance harsha

thanks guys the program worked, appreciate your help. harsha

Dear PHV and JarlH, there is only one table, we are comparing one row with another in the same table, so do i put something like SELECT t1.*,t2.* FROM tab t3 instead of SELECT t2.* FROM tab t1, tab t2 would it work? thank you harsha

Dear All, I am using a SQL server database with around 20 columns,all the columns have numeric values, I want to write an SQL statement which does the following: compare each row of the table with all other rows in the table and return all the rows that have a difference of + or - 0.5...