MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE student (
  `ano` INTEGER,
  `name` VARCHAR(8),
  `gender` VARCHAR(1),
  `age` INTEGER,
  `place` VARCHAR(7)
);

INSERT INTO student (`ano`, `name`, `gender`, `age`, `place`) VALUES
  ('114', 'ron', 'm', '18', 'cbe'),
  ('115', 'dhruv', 'm', '18', 'cbe'),
  ('116', 'mini', 'f', '23', 'chennai'),
  ('117', 'yash', 'm', '20', 'chennai'),
  ('118', 'aathmika', 'f', '19', 'delhi'),
  ('119', 'aadhi', 'm', '9', 'pune');
SELECT ANY_VALUE(ano) ano 
FROM student
WHERE age > 18
GROUP by place


ano


116

118


SELECT s.* 
FROM student s
INNER JOIN (
  SELECT ANY_VALUE(ano) ano 
  FROM student
  WHERE age > 18
  GROUP by place
) t ON t.ano = s.ano


ano
name
gender
age
place


116
mini
f
23
chennai

118
aathmika
f
19
delhi