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
- 14388 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 |
List out the acid properties and explain?
how to include character strings in sql statements? : Sql dba
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
what is a foreign key ? : Sql dba
What is a rank in sql?
Why stored procedure is faster than query?
what are all the different types of indexes? : Sql dba
What is bulk compiling in pl/sql.?
what is the difference between delete and truncate statement in sql? : Sql dba
Do prepared statements prevent sql injection?
What are the advantages of sql? Explain
Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?
-
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)
