How can i get unique rows in one sql statement | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

How can i get unique rows in one sql statement

using distinct

17th Apr 2018, 7:02 PM
Lalit Kumar
Lalit Kumar - avatar
6 Answers
17th Apr 2018, 7:10 PM
Tashi N
Tashi N - avatar
+ 3
Firstly, manners go a long way. Tashi gave you a reference to the answer based on your original question so the polite thing to do would be to say "thanks". Secondly, you've given very little information regarding your data but this reference may help: https://www.w3resource.com/sql/select-statement/queries-with-distinct-multiple-columns.php
17th Apr 2018, 8:03 PM
Duncan
Duncan - avatar
+ 2
Your not pathetic Lalit Kumar, your response just lacked gratitude :)
18th Apr 2018, 12:33 AM
Duncan
Duncan - avatar
+ 1
want distinct values simultaneously in both columns
17th Apr 2018, 7:12 PM
Lalit Kumar
Lalit Kumar - avatar
+ 1
I m still new and would learn the tricksoftrade from you guys only
17th Apr 2018, 8:20 PM
Lalit Kumar
Lalit Kumar - avatar
0
I m so pathetic...Duncan and tashi....that I forgot to thank...by the way I have already gone thru the Tut (s)he mentioned...and was asking out of curiosity....nothing formally....
17th Apr 2018, 8:18 PM
Lalit Kumar
Lalit Kumar - avatar