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
- 14432 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 a relationship and what are they? : Sql dba
How can I get the number of records affected by a stored procedure?
What Is a Trigger? How Do You Use It?
What is a relationship and what are they?
What are the types of optimization?
What is the diff between Truncate table / delete <table name> purge
What is a transaction?
What is trigger in pl sql with examples?
How do you select unique values in sql?
What are tables in sql?
How would you convert date into julian date format?
What does (*) mean in 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)
