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
- 10 Answers
- 17979 Views
- HCL, TCS, I also Faced
- E-Mail Answers
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
how to delete an existing column in a table? : Sql dba
What is on delete restrict?
Are stored procedures faster than dynamic sql?
I need a function for a train ticket reservation please answer it thanks in advance
Can we join more than 2 tables in sql?
What is recursive join in sql?
What is java sql connection?
Why having clause is used in sql?
Are null values same as that of zero or a blank space?
What is the difference between sql and mysql?
What are data types in pl sql?
What is cartesian join in sql?
What does plv msg allows you to do?
how many ways we can we find the current date using mysql? : Sql dba
What is trigger explain with example?
