Hi all,
I have a requirement to select only 2 records(sequentially or randomly) from a file for a test purpose.The file is like this,
11111 abcd jhgsdkfg jngsdkfjh klafgsf
11111 reyty rrtgrtgrt fgdfgfgfg fgsdgh
11111 wqre qerwerer erwerrtre retrttry
11111 rtrte ewrertrt rwetrtrtre tgertrtr
22222 abcd jhgsdkfg jngsdkfjh klafgsf
22222 reyty rrtgrtgrt fgdfgfgfg fgsdgh
22222 wqre qerwerer erwerrtre retrttry
22222 rtrte ewrertrt rwetrtrtr tgertrtr
I need to select only 2 records from 11111 and 22222 keys.I can use INCLUDE condition if the number of records are few.But I have a very big file having keys count to 1000.Kindly help.