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 / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the 3 types of behavioral triggers?

661


What is int identity in sql?

574


what are the different type of normalization? : Sql dba

554


What does the hierarchical profiler does?

566


Is it mandatory for the primary key to be given a value when a new record is inserted?

708






What is varchar sql?

617


What are the advantages of normalization?

554


What is database migration?

517


What is cursor in pl sql with examples?

481


Is foreign key mandatory?

554


how to fetch alternate records from a table? : Sql dba

592


how to drop an existing index in mysql? : Sql dba

536


What is pessimistic concurrency control? : Transact sql

584


Which data dictionary views have the information on the triggers that are available in the database?

754


What is difference between hql and sql?

503