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 procedure explain with program?
What is sql trigger example?
Explain the working of primary key?
How do I partition in sql?
What is error ora-01000: maximum open cursors exceeded
How to convert comma separated string to array in pl/sql?
what is 'mysqlshow'? : Sql dba
What are the operators used in select statements?
Define commit, rollback and savepoint?
What packages are available to pl/sql developers?
What does an inner join do?
Which is faster union or join?
What is fmtonly in sql?
What is the use of prepared statement?
Can a table have no primary key?