what is the correct way of selection statement
a. select/from/table_name/orderby/groupby/having
b. select/from/table_name/groupby/having/orderby
- 5 Answers
- 12889 Views
- HCL, JPMorgan Chase, I also Faced
- E-Mail Answers
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
Explain the working of primary key?
Is primary key is clustered index?
What is input buffer in sql*plus?
what is the difference between undefined value and null value? : Sql dba
How is data stored on a disk?
What are the possible values that can be stored in a boolean data field?
What is pivot query?
What is primary key and unique key?
What is trigger point?
How do you declare a user-defined exception?
What are the different types of tables in sql?
What is normalisation and its types?
What are the different ways to optimize a sql query?
What is cursor and why it is required?
What are pl/sql packages?
