Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 synchronized subquery?

0 Answers  

Differences between UNIQUE and DISTINCT in select statements

26 Answers   ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,

Explain the difference between rename and alias?

0 Answers  

What is the difference between anonymous block and named block or stored procedure?

8 Answers  

what does the t-sql command ident_incr does? : Transact sql

0 Answers  

What is database sql?

0 Answers  

what is try_catch block in procedure

0 Answers  

How do I run sql profiler?

0 Answers  

Does inner join return duplicate rows?

0 Answers  

What is sqlerrd?

0 Answers  

What are the types of sql commands?

0 Answers  

What are the different types of sql commands?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories