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;