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 |
What is pivot table in sql?
What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?
What is nvarchar max in sql?
What are triggers in sql?
What does t sql mean?
Difference between inline query and stored procedure?
what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?
What is pls_integer in pl sql?
Can we create table inside stored procedure?
what is sql? : Sql dba
What are the usages of sql?
How to return an array from java to pl/sql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)