The Gateway to Computer Science Excellence
For all GATE CSE Questions
Toggle navigation
Facebook Login
or
Email or Username
Password
Remember
Login
Register
|
I forgot my password
Activity
Questions
Unanswered
Tags
Subjects
Users
Ask
Prev
Blogs
New Blog
Exams
give statement in english for SQL
0
votes
176
views
databases
sql
asked
Jul 16, 2015
in
Databases
by
focus _GATE
Boss
(
20k
points)
|
176
views
answer
comment
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
1
Answer
+2
votes
Best answer
Students who have enrolled for a course in CS department but not in ME department.
answered
Jul 16, 2015
by
Arjun
Veteran
(
425k
points)
selected
Jan 27, 2016
by
Pooja Palod
comment
+1
sir,,wt u told i also think same.!!
ans is given as bellow.!!
Finds the students who are enrolled in atleast one course by CS
department and not enrolled in all courses offered by ME department
Please
log in
or
register
to add a comment.
← Prev. Qn. in Sub.
Next Qn. in Sub. →
← Prev.
Next →
Related questions
0
votes
0
answers
1
Any good resource for developing concepts on transactions in SQL?
asked
May 9
in
Databases
by
aditi19
Active
(
5.1k
points)
|
50
views
sql
transactions
transaction-and-concurrency
databases
database
0
votes
0
answers
2
Assertions in SQL-Self Doubt
Whenever Assertions are created, the predicate that the Assertion specifies must hold true at the time of assertion creation. Now Whenever we make changes to any table in the database, do all the assertions present in the database are checked ... all Assertions are checked and executed (Even when some assertions are not related to the tables which have been changed)?
asked
Oct 14, 2018
in
Databases
by
Ayush Upadhyaya
Boss
(
27.8k
points)
|
43
views
databases
sql
0
votes
0
answers
3
SQL query with NOT IN connective.
a) 0 b) 1 c) 2 d) 3
asked
Sep 15, 2018
in
Databases
by
Nirmal Gaur
Active
(
2.1k
points)
|
96
views
sql
query
databases
0
votes
0
answers
4
Update, Delete and Insert via View in SQL
Hi Guys, In what situation Update, Delete and Insert operation could be performed via view ? Please provide some kind of proof to support your answer. It will be really helpful. PS: http://www.geekinterview.com/question_details/4529 ... modify-data-through-a-view http://www.sqlservercentral.com/blogs/sqldbauk/2011/07/11/can-you-delete-from-a-view_3F00_/
asked
Dec 11, 2017
in
Databases
by
Chhotu
Boss
(
13.3k
points)
|
67
views
databases
sql
view
Quick search syntax
tags
tag:apple
author
user:martin
title
title:apple
content
content:apple
exclude
-tag:apple
force match
+apple
views
views:100
score
score:10
answers
answers:2
is accepted
isaccepted:true
is closed
isclosed:true
Recent Posts
ECIL Interview Experience
Linear Algebra Important Points
GATE 2020
OFFICIAL GATE MOCK TEST RELEASED
IIITH: Winter Research Admissions 2019 (For Spring 2020)
All categories
General Aptitude
1.9k
Engineering Mathematics
7.5k
Digital Logic
2.9k
Programming and DS
4.9k
Algorithms
4.3k
Theory of Computation
6.2k
Compiler Design
2.1k
Operating System
4.5k
Databases
4.1k
CO and Architecture
3.4k
Computer Networks
4.1k
Non GATE
1.5k
Others
1.5k
Admissions
595
Exam Queries
576
Tier 1 Placement Questions
23
Job Queries
72
Projects
17
Follow @csegate
Recent Blog Comments
@Ayush Upadhyaya sir any approximate idea...
@Ayush Upadhyaya Thank you so much! ^_^
@JashanArora-No No. Don't directly say no.Think a...
@jeet-Yes, I am sorry for that.I saw ECIL Advt...
Congratulations man! A little question, please?...
50,645
questions
56,588
answers
195,788
comments
101,846
users