Which query shows the first name, department, and team of all students with the two lowest points?
SELECT BOTTOM(2) first_name, department, team FROM Students ORDER BY points ASC;
the picture of table is important here and there it can be seen that there are only two value with min points. Secondly, the previous answer was wrong because order by DESC will put highest points into the beginning of result list and TOP(2) will take first two highest points, and we need the lowest points.
DESC
TOP(2)
SELECT TOP(2) WITH TIES first_name, department, team FROM Students ORDER BY points;
SELECT TOP(2) first_name, deprtment, team FROM Students ORDER BY points DESC;
SELECT LIMIT(2) first_name, department, team FROM Students ORDER BY points ASC;