what is the correct way of selection statement
a. select/from/table_name/orderby/groupby/having
b. select/from/table_name/groupby/having/orderby
Answer Posted / kavitha nedigunta
b. select/from/table_name/groupby/having/orderby
EG: select deptno,max(sal)
from emp
group by deptno
having max(sal)> 5000
order by deptno
| Is This Answer Correct ? | 69 Yes | 1 No |
Post New Answer View All Answers
What are functions in sql?
How do we accept inputs from user during runtime?
Why indexing is needed?
What is difference between table and view?
What is union?
What is a primary key called that is made up of more than one field?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
What is data manipulation language?
What is difference between my sql and sql?
How do I find duplicates in two columns?
How do I enable sql encryption?
What are pl/sql packages?
Which software is used for pl sql programming?
What are sql*plus environment variables?
How do I run a sql query?