Which of the following statements are TRUE about an SQL query gate cse 2012
The Eduladder is a community of students, teachers, and programmers just interested to make you pass any exams. So we solve previous year question papers for you.
See Our team
Wondering how we keep quality?
Got unsolved questions?

Ask Questions
Hey! Want to work with us? Our youtube channel See our Jd Want to apply? Do it today

Use Me  ?

New searches
gate-cse-2012-->View question


Which of the following statements are TRUE about an SQL query? -gate-cse-2012

P : An SQL query can contain a HAVING clause even 
    if it does not have a GROUP BY clause
Q : An SQL query can contain a HAVING clause only
    if it has a GROUP BY clause
R : All attributes used in the GROUP BY clause must
    appear in the SELECT clause
S : Not all attributes used in the GROUP BY clause
    need to appear in the SELECT clause 
A.P and R
B.P and S
C.Q and R
D.Q and S


By:prajwalamv

Taged users:


Likes:
Be first to like this question

Dislikes:
Be first to dislike this question

Talk about thisDelete|Like|Dislike|


Answers

(C) Q and R

Explanation: According to standard SQL answer should be C. Refer

If we talk about different SQL implementations like MySQL, then option B is also right. But in question they seem to be talking about standard SQL not about implementation. For example below is a

P is correct in most of the implementations. HAVING clause can also be used with aggregate function. If we use a HAVING clause without a GROUP BY clause, the HAVING condition applies to all rows that satisfy the search condition. In other words, all rows that satisfy the search condition make up a single group. See this for more details.

S is correct . To verify S, try following queries in SQL.

CREATE TABLE temp 
  ( 
     id   INT, 
     name VARCHAR(100) 
  ); 

INSERT INTO temp VALUES (1, "abc"); 
INSERT INTO temp VALUES (2, "abc"); 
INSERT INTO temp VALUES (3, "bcd"); 
INSERT INTO temp VALUES (4, "cde"); 

SELECT Count(*) 
FROM   temp 
GROUP  BY name; 
Output:

count(*)
--------
2
1
1


milan-ransingh

Likes:
Be first to like this answer

Dislikes:
Be first to dislike this answer
Talk about this|Once you have earned teacher badge you can edit this questionDelete|Like|Dislike|
------------------------------------

Can you help us to add better answer here? Please see this



Not the answer you're looking for? Browse other questions from this Question paper or ask your own question.

Join eduladder!