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
- 13638 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 faster join or subquery?
how to create a table index in mysql? : Sql dba
Can we create clustered index without primary key?
Can we create table in function?
What is the difference between sql and mysql?
Mention what is the plv (pl/vision) package offers?
How to get the procedure's, function's name from a package if it is wrapped(both spec & body).
What are primary key and foreign key and how they work?
What is nested table in pl sql?
What is a 'instead of trigger'?
What is latest version of sql?
what are the types of subquery? : Sql dba
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
