Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14614 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
What is a loop in sql?
How does rowid help in running a query faster?
How can the performance of a trigger be improved?
What is embedded sql what are its advantages?
What is use of package in pl sql?
What is clause?
What is the syntax and use of the coalesce function?
What is the difference between inner join and left join?
How do you take the union of two tables in sql?
List different type of expressions with the example.
Can we create foreign key without primary key?
What are expressions?
How to write a query to show the details of a student from students table whose
How to revise and re-run the last sql command?
How is debugging done?
