Register

query on notexists

142 views

Please log in or register to answer this question.

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

Related questions

0 votes
0 votes
0 answers
1
Tuhin Dutta asked Dec 15, 2017
410 views
DBMS sql query on null
Student table ROLLNO NAME MARKS1 MARKS2 1 T 50 30 2 S 70 99 3 D NULL 10 NULL NULL 78 NULL NULL NULL NULL NULL a) select count(MARKS1) from student; b) select count(*) from student;
Student tableROLLNONAMEMARKS1MARKS21T50302S70993DNULL10NULLNULL78NULLNULLNULLNULLNULLa) select count(MARKS1) from student;b) select count(*) from student;
User Avatar
0 votes
0 votes
0 answers
2
shikharV asked Jan 4, 2016
391 views
Question on calculating the number of tuples in result of a database query
I couldn't understand its solution. Please explain
I couldn't understand its solution. Please explain
User Avatar
1 votes
1 votes
1 answer
3
worst_engineer asked Oct 3, 2015
766 views
DBMS question on SQL query (2)
The answer given is (b) But  , according to given query , isn't it d) ?
The answer given is (b)But  , according to given query , isn't it d) ?
User Avatar
1 votes
1 votes
2 answers
4
worst_engineer asked Oct 3, 2015
1,215 views
DBMS question on SQL query
Hi , I tried to solve it in this way -- inner query returning zero tuples. So , outer query becomes select * from table1 where not exists null ( i mean no tuple ). basically , it should give me all the tuples , right ? I know , i am wrong , please clarify.  
Hi , I tried to solve it in this way inner query returning zero tuples.So , outer query becomes select * from table1 where not exists null ( i mean no tuple ).basically...
User Avatar
Link Copied!