ЁЯТ╛ SQL Practice Questions – Part 2(Basic Level)
ЁЯФ╣ Question 11 – Select Multiple Columns
Tamil:
students table-роЗро▓் роЗро░ுрои்родு
name рооро▒்ро▒ுроо் age роороЯ்роЯுроо் display роЪெроп்ропுроЩ்роХро│்.
English:
Display only name and age columns from students table.
ЁЯФ╣ Question 12 – Greater Than Condition
Tamil:
18 ро╡ропродுроХ்роХு рооேро▓் роЙро│்ро│ students-роР display роЪெроп்ропுроЩ்роХро│்.
English:
Display students whose age is greater than 18.
ЁЯФ╣ Question 13 – Less Than Condition
Tamil:
18 ро╡ропродுроХ்роХு роХுро▒ைро╡ாрой students-роР display роЪெроп்ропுроЩ்роХро│்.
English:
Display students whose age is less than 18.
ЁЯФ╣ Question 14 – AND Condition
Tamil:
age 17 рооро▒்ро▒ுроо் name "Santhosh" роЙро│்ро│ record-роР display роЪெроп்ропுроЩ்роХро│்.
English:
Display records where age is 17 AND name is "Santhosh".
ЁЯФ╣ Question 15 – OR Condition
Tamil:
age 17 роЕро▓்ро▓родு age 19 роЙро│்ро│ students-роР display роЪெроп்ропுроЩ்роХро│்.
English:
Display students whose age is 17 OR 19.
ЁЯФ╣ Question 16 – Order By Ascending
Tamil:
students table-роР age роЕроЯிрок்рокроЯைропிро▓் ascending order-ро▓் sort роЪெроп்ропுроЩ்роХро│்.
English:
Sort students table by age in ascending order.
ЁЯФ╣ Question 17 – Order By Descending
Tamil:
students table-роР age роЕроЯிрок்рокроЯைропிро▓் descending order-ро▓் sort роЪெроп்ропுроЩ்роХро│்.
English:
Sort students table by age in descending order.
ЁЯФ╣ Question 18 – Count Records
Tamil:
students table-роЗро▓் рооொрод்родрооாроХ роОрод்родройை records роЙро│்ро│рой роОрой்ро▒ு count роЪெроп்ропுроЩ்роХро│்.
English:
Count total number of records in students table.
ЁЯФ╣ Question 19 – Maximum Age
Tamil:
students table-роЗро▓் роЕродிроХрооாрой ро╡ропродை роХрог்роЯро▒ிропுроЩ்роХро│்.
English:
Find the maximum age in students table.
ЁЯФ╣ Question 20 – Minimum Age
Tamil:
students table-роЗро▓் роХுро▒ைрои்род ро╡ропродை роХрог்роЯро▒ிропுроЩ்роХро│்.
English:
Find the minimum age in students table.
Answer
Comments
Post a Comment