If you want a column to be part of the result set, after
which SQL keyword does it belong?
1. SELECT
2. FROM
3. WHERE
4. GROUP BY
5. HAVING
Answer Posted / sumitha
It is Select.
Bcoz
2) from : includes the table name (source and not columns)
3)Where : specifies the condition based on which the rows
are retrived
4) Group by : mentions the column on which the rows are to
be grouped.. note that the column name mentioned should
also be specified in the select clause
5) Having : not sure
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is composite primary key in sql?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
How do I view output in sql developer?
discuss about myisam key cache. : Sql dba
Which is the correct statement about truncate and delete?
what is a database transaction? : Sql dba
What is pragma in pl sql?
What is a mutating table and a constraining table?
Is subquery faster than join?
What is rowtype?
How do you update sql?
How do you update a table in sql?
Which is better stored procedure or query?
Does truncate table reset auto increment?
What are the topics in pl sql?