Back to General and Gameplay Programming

SQL query question

General and Gameplay Programming Programming

Started by cpp_boy April 03, 2006 05:05 AM

1 comment, last by eastcoastsurfer 18 years ago

cpp_boy

100

Author

April 03, 2006 05:05 AM

Hello. I have table with 2 columns, non of them is a key. I need query that will NOT select duplicated rows, only one occurrence of each row kind will appear after this select. Thanks in advance.

Jockel

144

April 03, 2006 07:25 AM

Use the 'distinct' clause, eg. select distinct * from table

eastcoastsurfer

127

April 03, 2006 09:21 AM

You can also use a group by clause.

This topic is closed to new replies.

Popular Topics

How do you manage yourself and your time as years pass on? GDNet Lounge

Too many managers? General and Gameplay Programming

Do your part to stop global warming and climate change GDNet Lounge

The promise of freedom in story games Game Design and Theory

Facebook Ads for sales on steam, does it work? Games Business and Law

Understanding the wavy-like shape in alpha-testing magnification for text rendering Graphics and GPU Programming

Recommended Tutorials

Entering The 3rd Dimension Graphics and GPU Programming

Peter Stock Interviews

Win32 Assembly Part 4 General and Gameplay Programming

Clock Synchronization of Client Programs Networking and Multiplayer

Compressed Quantized Unit Vectors Math and Physics

SQL query question

This topic is closed to new replies.

Popular Topics

Recommended Tutorials

Reticulating splines