+ 4

In which order we should place the "ORDER BY" & "WHERE CLAUSE" ??

29th Nov 2016, 3:15 AM
Jenny Lance
Jenny Lance - avatar
3 odpowiedzi
+ 12
I think the correct sequence to use some of the common commands is Select From Where Group By Having Order by
29th Nov 2016, 3:28 AM
Megatron
Megatron - avatar
0
ORDER BY always at the end of statement.
2nd Dec 2016, 9:14 AM
Ashraf Al Karaki
Ashraf Al Karaki - avatar
0
select distinct count from where group by having order by
5th Jan 2017, 8:34 PM
Srinath Gatla
Srinath Gatla - avatar