Oracle SQL get one of each data

If I had a table with a column of Hello and I had multiple rows with the data 'World' and multiple with the data Dave (There are other columns too) and I wanted to select all the different types of data within the Hello column.

So basically I would be looking for a return with two results, one being World and the other being Dave.

Another option would be to count the how many different data pieces there are in the column(2 in this case) and searching with that as a rownum and sorting the results (Although I'd assume this was a very similar search.)

Thanks

Answers


if you don't want duplicates in the result - add distinct :

select distinct hello from yourTable

and if you want to count different values :

select hello, count(*) from yourTable group by hello


Need Your Help

Two webhooks with the same URL

shopify webhooks

If I have two Shopify apps that have configured webhooks pointing to the same URL for the same events - when one of those events gets fired, will my webhook get fired once, or twice?

Integrate DTCoreText with xcode project

objective-c ios xcode cocoa-touch xcode4

I wanted to convert from html to NSAttributedString, and i found away solving this using DTCoreText here https://github.com/Cocoanetics/DTCoreText

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.