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
- 14796 Views
- HCL, JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
How do you know if a relationship is 2nf?
Explain the rollback statement?
What are the two types of periodical indexes?
Will truncate release space?
how to convert character strings to dates? : Sql dba
What type of database is cloud sql?
What type of database is sql?
How many sql statements are used? Define them.
What are the basic techniques of indexing?
What does dml mean?
What is a database? Explain
How can we store rows in PL/SQL using array?
Define implicit and explicit cursors.
what is a composite primary key ? : Sql dba
