1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / suresh

Answers were Sorted based on User's Feedback



If you want a column to be part of the result set, after which SQL keyword does it belong? ..

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

If you want a column to be part of the result set, after which SQL keyword does it belong? ..

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

If you want a column to be part of the result set, after which SQL keyword does it belong? ..

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

If you want a column to be part of the result set, after which SQL keyword does it belong? ..

Answer / harshika

select

Is This Answer Correct ?    6 Yes 0 No

If you want a column to be part of the result set, after which SQL keyword does it belong? ..

Answer / archana

select

Is This Answer Correct ?    4 Yes 0 No

If you want a column to be part of the result set, after which SQL keyword does it belong? ..

Answer / chandrasekar.ramasamy

Group by

Is This Answer Correct ?    4 Yes 3 No

If you want a column to be part of the result set, after which SQL keyword does it belong? ..

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

If you want a column to be part of the result set, after which SQL keyword does it belong? ..

Answer / menan

having

Is This Answer Correct ?    0 Yes 4 No

If you want a column to be part of the result set, after which SQL keyword does it belong? ..

Answer / priya verma

grout by

Is This Answer Correct ?    0 Yes 5 No

If you want a column to be part of the result set, after which SQL keyword does it belong? ..

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

Post New Answer

More SQL PLSQL Interview Questions

how to saw triggers output in pl/sql database?

1 Answers  

What is sql profiling in oracle?

0 Answers  

How do you declare a constant?

0 Answers  

What is the difference between subquery and correlated query?

0 Answers  

What is sql not null constraint?

0 Answers  




check whether all the emp numbers are indeed unique.

6 Answers  

what are the types of subquery? : Sql dba

0 Answers  

Is primary key a clustered index?

0 Answers  

what is bdb (berkeleydb)? : Sql dba

0 Answers  

What are the types of operators available in sql?

0 Answers  

What is foreign key in sql with example?

0 Answers  

What does the argument [or replace] do?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories