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

What is secondary key?

0 Answers  

how to add a new column to an existing table in mysql? : Sql dba

0 Answers  

What is sql comments?

0 Answers  

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

What are the basic techniques of indexing?

0 Answers  




what is the functionality of the function htmlentities? : Sql dba

0 Answers  

How is Oracle 10g helpful when compared to oracle 9i and what is grid computing

1 Answers   Flextronics,

What is a schema sql?

0 Answers  

What is the max nvarchar size?

0 Answers  

Explain the update statement in sql

0 Answers  

PL/SQL allocates memory for the variable's at runtime or at compile time

3 Answers  

What is the basic difference between a sql and stored procedure ?

2 Answers   L&T,

For more SQL PLSQL Interview Questions Click Here
Categories