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
Answers were Sorted based on User's Feedback
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 |
Answer / avinash hiwarale
Select
it gives you the option to choose the column you want to
see.
Is This Answer Correct ? | 10 Yes | 0 No |
Answer / sathishrpillai
if you want a column to be a part of result set then it
SELECT
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / rampratap singh
After Select
because Result set is the feature of java and it will hold
a record (list of columns) from column clause only
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / j.t.karthikeyan
The word result set is nothing but aggregation.
GROUP BY is the right answer.
Result set like Groupin, Grouping SETS etc...
Is This Answer Correct ? | 0 Yes | 8 No |
How is Oracle 10g helpful when compared to oracle 9i and what is grid computing
how to saw triggers output in pl/sql database?
What is a .db file?
What is trigger explain with example?
What is a primary key called that is made up of more than one field?
there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?
How to return multiple rows from the stored procedure?
How to Execute a Package in PL/SQL.?
What is the use of index in sql?
What is oracle and pl sql?
What is Materialized View? In What Scenario we Use Materialized View?
How can you fetch first 5 characters of the string?