SQL Challenges-1: Unique values

Last update on May 30 2022 07:33:29 (UTC/GMT +8 hours)

SQL Challenges-1: Exercise-14 with Solution

From the following table, write a SQL query to find the unique marks. Return the unique marks.

Input:

Table: student_test

Structure:

Field	Type	Null	Key	Default	Extra
student_id	int(11)	YES
marks_achieved	int(11)	YES

Data:

student_id	marks_achieved
1	56
2	74
3	15
4	74
5	89
6	56
7	93

Sample Solution:

SQL Code(MySQL):

DROP TABLE IF EXISTS student_test;
CREATE TABLE student_test(student_id int,  marks_achieved int);
INSERT INTO student_test VALUES (1, 56);
INSERT INTO student_test VALUES (2, 74);
INSERT INTO student_test VALUES (3, 15);
INSERT INTO student_test VALUES (4, 74);
INSERT INTO student_test VALUES (5, 89);
INSERT INTO student_test VALUES (6, 56);
INSERT INTO student_test VALUES (7, 93);
SELECT * FROM student_test;
SELECT DISTINCT(marks_achieved) AS  'Unique Marks' FROM student_test;

Sample Output:

Unique Marks|
------------|
          56|
          74|
          15|
          89|
          93|

SQL Code Editor:

Contribute your code and comments through Disqus.

Previous: Find the even or odd values.
Next: Find Student Supporter.

SQL: Tips of the Day

SQL Server SELECT into existing table.

INSERT INTO dbo.TABLETWO SELECT col1, col2 FROM dbo.TABLEONE WHERE col3 LIKE @search_key

This assumes there's only two columns in dbo.TABLETWO - you need to specify the columns otherwise:

INSERT INTO dbo.TABLETWO (col1, col2) SELECT col1, col2 FROM dbo.TABLEONE WHERE col3 LIKE @search_key

Database: SQL Server

Ref: https://bit.ly/3y6tpA3