Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

how to Display a single value from multiple values in sql ?

Home
Forums
SQL

how to Display a single value from multiple values in sql ?

Subin Thomas

Subin Thomas

7yAsked Mar 14, 2019, 4:58 AM1.9kSQL

i have same project name multiple times in my table that is not because of redundancy it is multiple times for some reason

how to take a single value from multiple values

for eg

project name

a

b

a

c

b

a

i want it as

project name

a

b

c

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Bidyasagar Mishra7y ago
1. select distinct ProjectName from Project

Gajendra Jangid

Gajendra Jangid7y ago

hello dear ,

try like as below:

SELECT DISTINCT projectname FROM tble

Jignesh Kumar

Jignesh Kumar7y ago

Hi Subin,

You can do it couple of way,

select distinct ProjectName from Project
select ProjectName from Project group by ProjectName

Sanwar Ranwa

Sanwar Ranwa7y ago

Hello Subin

check given query

CREATE TABLE T1(id INT,projectname VARCHAR(50))
INSERT INTO T1 VALUES(1,'a')
INSERT INTO T1 VALUES(1,'b')
INSERT INTO T1 VALUES(1,'a')
INSERT INTO T1 VALUES(1,'c')
INSERT INTO T1 VALUES(1,'b')
INSERT INTO T1 VALUES(1,'a')
SELECT DISTINCT projectname FROM T1 t

Madan Shekar

Madan Shekar7y ago

SELECT DISTINCT column-name

FROM table-name

mark as answer if it helps you