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 are the types of dbms?
Could you please provide oca (oracle 10g) dumps for my certification ?
What is coalesce sql?
What is the meaning of disabling a trigger?
Is sql easier than java?
Why is %isopen always false for an implicit cursor?
Does pdo prevent sql injection?
What are the types of index in sql?
What is sql partition?
Is primary key always clustered index?
How to check if a column is nullable before setting to nullable?
What is index example?
Does execute immediate commit?
Mention what plvcmt and plvrb does in pl/sql?
Explain the the delete statements in sql?