I have seen many queries with something as follows. Select 1 From table What does this 1 mean, how will it be executed and, what will it return? Also, in what type of scenarios, can this be used? 15 Answers 15
What is the difference between SQL, PL-SQL and T-SQL? Can anyone explain what the differences between these three are, and provide scenarios where each would be relevantly used? 6 Answers 6
In SQL I (sadly) often have to use “LIKE” conditions due to databases that violate nearly every rule of normalization. I can’t change that right now. But that’s irrelevant to the question. Further, I often use conditions like WHERE something in (1,1,2,3,5,8,13,21) for better readability and flexibility of my SQL statements. Is there any possible … Read more
