Awesome q2a theme
0 votes
37 views
if sql query does not have any tuple to return then what will it return?either null or zero
in Databases by (13 points) | 37 views
0
I think answer will be NULL because returning 0 is still a tuple.
I am not sure

1 Answer

0 votes
nothing will be returned as your table has nothing.

 

example suppose

I have a table A

 

if I do,

 

SELECT * FROM A;

OUTPUT:

 

NOTE: YOU WOULD NOT GET NULL WRITTEN THERE.
by (715 points)
0
So something like void?
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
Welcome to GATE CSE Doubts, where you can ask questions and receive answers from other members of the community.
8,675 questions
2,878 answers
13,796 comments
95,575 users