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 auto increment in sql?

0 Answers  

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,

Does truncate remove indexes?

0 Answers  

What is %type in pl sql?

0 Answers  

Can a view be updated/inserted/deleted?If Yes under what conditions?

3 Answers  

How do I find duplicates in two columns?

0 Answers  

What is the use of partition by in sql?

0 Answers  

What is self-join and what is the requirement of self-join?

0 Answers  

What is composite data type in pl sql?

0 Answers  

How delete all data from all tables in sql?

0 Answers  

How do you delete duplicates in sql query using rowid?

0 Answers  

Is sql a case sensitive language?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories