import java.util.regex.*;
import java.util.*;
import java.lang.*;
import java.io.*;
 
class Ideone
{
	public static void main (String[] args) throws java.lang.Exception
	{
		String regex = "\\G(?:(?!\\bfrom\\b).)*?\\bas\\s+(\\w+)";
		String string = "select b.no as no, b.number_car as number_car from car as b where a.no = 2";
 
		Pattern pattern = Pattern.compile(regex);
		Matcher matcher = pattern.matcher(string);
 
		while (matcher.find()) {
		    System.out.println(matcher.group(1));
		}
	}
}

aW1wb3J0IGphdmEudXRpbC5yZWdleC4qOwppbXBvcnQgamF2YS51dGlsLio7CmltcG9ydCBqYXZhLmxhbmcuKjsKaW1wb3J0IGphdmEuaW8uKjsKCmNsYXNzIElkZW9uZQp7CglwdWJsaWMgc3RhdGljIHZvaWQgbWFpbiAoU3RyaW5nW10gYXJncykgdGhyb3dzIGphdmEubGFuZy5FeGNlcHRpb24KCXsKCQlTdHJpbmcgcmVnZXggPSAiXFxHKD86KD8hXFxiZnJvbVxcYikuKSo/XFxiYXNcXHMrKFxcdyspIjsKCQlTdHJpbmcgc3RyaW5nID0gInNlbGVjdCBiLm5vIGFzIG5vLCBiLm51bWJlcl9jYXIgYXMgbnVtYmVyX2NhciBmcm9tIGNhciBhcyBiIHdoZXJlIGEubm8gPSAyIjsKCQkKCQlQYXR0ZXJuIHBhdHRlcm4gPSBQYXR0ZXJuLmNvbXBpbGUocmVnZXgpOwoJCU1hdGNoZXIgbWF0Y2hlciA9IHBhdHRlcm4ubWF0Y2hlcihzdHJpbmcpOwoJCQoJCXdoaWxlIChtYXRjaGVyLmZpbmQoKSkgewoJCSAgICBTeXN0ZW0ub3V0LnByaW50bG4obWF0Y2hlci5ncm91cCgxKSk7CgkJfQoJfQp9