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 are all the common sql function? : Sql dba

0 Answers  

Write a query to display the current date in sql?

0 Answers  

what is the difference between cursor FETCH and FOR LOOP ?

3 Answers   CG-VAK, Tech Mahindra,

How do you explain an index number?

0 Answers  

What is the difference between a query and a report?

0 Answers  

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy

6 Answers   Target,

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

0 Answers  

Explain ddl statements in pl/sql?

0 Answers  

What is update query?

0 Answers  

What is difference between nchar and nvarchar?

0 Answers  

What are the different types of constraints?

0 Answers  

how to shutdown mysql server? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories