The data from t1 table is:
Assuming You want to see this output:
Which query achieves the preceding result?
A.
SELECT name FROM t1 WHERE name LIKE ,_e%
B.
SELECT name FROM t1 WHERE name LIKE,e%.;
C.
SELECT name FROM t1 GROUP BY name ORDER by name LIMIT 1,1;
D.
SELECT name FROM t1 GROUP BY name HAVING sun ( marks)=176 ORDER BY
name;
C
create table t1
(
`name` char(10),
`subject` char(10),
marks int
);
insert into t1 values
(‘Kristofer’,’Computer’,95),
(‘Kristofer’,’English’,75),
(‘George’,’Computer’,85),
(‘George’,’English’,91),
(‘Alice’,’Computer’,81),
(‘Alice’,’English’,77),
(‘Peter’,’Computer’,99),
(‘Peter’,’English’,77);
SELECT `name` FROM t1 GROUP BY `name` ORDER by `name` LIMIT 1,1;
name
‘George’
C
C