selecting one record out of 2 records

naveenkumar.ssn · Post by **naveenkumar.ssn** » Wed Jan 06, 2016 9:59 pm

vamsi_4a6 wrote:I have concatenated as mentioned below

Start,End,Start_End,End_Start,Distance
Bangalore,Mumbai,BangaloreMumbai,MumbaiBangalore,1500
Hyderabad,Delhi,HyderabadDelhi,DelhiHyderabad,2000
Delhi,Hyderabad,DelhiHyderabad,HyderabadDelhi,2000
Mumbai,Bangalore,MumbaiBangalore,BangaloreMumbai,1500

How to use above Start_End,End_Start columns for comparisions?

Hi,

Use the substring function to check whether the string exist in the column.

Regards
Naveen

chulett · Post by **chulett** » Thu Jan 07, 2016 9:30 am

chulett wrote:Your example doesn't seem to match up to your words. "1 out of 2 records" means what exactly - every other record? Every even? Every odd? Something else entirely? All your example shows are the first two records being 'selected'.

I don't know about anyone else but I for one would like to see this question put to bed, something that never was addressed. I don't see how anyone can expect a precise solution for a problem that can't be articulated... precisely.