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
- 14633 Views
- HCL, JPMorgan Chase, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / iamanocp
Answer is b.
b. select/from/table_name/groupby/having/orderby
| Is This Answer Correct ? | 18 Yes | 0 No |
Answer / anil kumar jaiswal
the sequence is like this :
select
from
table_name
where
group by
having
order by.
where ever writing a sql query the sequence should be in this order.
so the answer B is correct.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / subbu
both are wrong
from/table_name/group by/having/select/oderby
| Is This Answer Correct ? | 3 Yes | 13 No |
What is difference between inner join and self join?
What is forward declaration in pl sql?
Why is a primary key important?
How do I get sql certification?
Explain what is a subquery ?
can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is schema in sql example?
What is a subquery in sql?
Explain 3 basic parts of a trigger.
What is java sql driver?
How do I install sql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
