SQL
***CREATE / INSERT *** create table TestTable (name varchar(20), age int, email varchar(20)); Insert into TestTable values(" abc ",23," jain@gmail.com "),("abc",30,"abc@gmail.com"),("www",50,"abc@gmail.com"),(" abc ",20,"abc@gmail.com"),("tta",10,"abc@gmail.com"); -- Insert into sresthaTable values("abc",30," abc@gmail.com "); -- select age from TestTable ; ***Maximum / Minimum Age*** -- select max(age) from TestTable where age <(select max(age) from sresthaTable where age <(select max(age) from sresthaTable )); -- select age from TestTable order by age limit 2-1,1; select name,age from TestTable where name like '%a' or age <30;