1
$\begingroup$

How to display distinct rows from single column without using DISTINCT keyword and [having count(*) > 1 ] ? My question is can we do this using sub-queries or co-related sub query ? If yes how we can do this ?

Please let me know. Thanks.

$\endgroup$

closed as off-topic by Yuval Filmus, David Richerby, D.W., Rick Decker, vonbrand Mar 3 '14 at 3:13

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions about software development or programming tools are off-topic here, but can be asked on Stack Overflow." – Yuval Filmus, David Richerby, D.W., Rick Decker, vonbrand
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 2
    $\begingroup$ This seems to be, essentially, a programming question, which would be off-topic, here. $\endgroup$ – David Richerby Mar 2 '14 at 17:24
  • $\begingroup$ Hi,I need SQL Query for that. I don't need any programming for this question. Can we write SQL Query for this ? $\endgroup$ – user2974606 Mar 3 '14 at 11:10
  • $\begingroup$ An SQL query is a program. $\endgroup$ – David Richerby Mar 3 '14 at 11:11