Register

UGC NET CSE | August 2016 | Part 2 | Question: 20

• recategorized by
1,726 views
1 votes
1 votes

Consider a database table $R$ with attributes $A$ and $B$. Which of the following $SQL$ queries is illegal ?

  1. SELECT A FROM R;
  2. SELECT A, COUNT(*) FROM R;
  3. SELECT A, COUNT(*) FROM R GROUP BY A;
  4. SELECT A, B, COUNT(*) FROM R GROUP BY A, B;
• recategorized by
User Avatar

1 Answer

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
1 answer
3
makhdoom ghaya asked Sep 24, 2016
1,427 views
UGC NET CSE | August 2016 | Part 2 | Question: 16
DBMS provides the facility of accessing data from a database through DDL DML DBA Schema
DBMS provides the facility of accessing data from a database throughDDLDMLDBASchema
User Avatar
2 votes
2 votes
1 answer
4
makhdoom ghaya asked Sep 28, 2016
2,849 views
UGC NET CSE | August 2016 | Part 2 | Question: 50
In Data mining, ______ is a method of incremental conceptual clustering. STRING COBWEB CORBA OLAD
In Data mining, ______ is a method of incremental conceptual clustering.STRINGCOBWEBCORBAOLAD
User Avatar
Link Copied!