what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;
Answers were Sorted based on User's Feedback
Answer / phani
In First case it will not return any rows. only the colum
names will be displayed.
In the second case all the records that are available in
the table will be displayed.
Is This Answer Correct ? | 61 Yes | 1 No |
Answer / jay vardhan singh
select * from Emp where null = null;
null can not be equal to null.So,Condition is not satisfied.
So,it will give only column name.
select * from Emp where 1=1;
1 is always equal to 1.So,Condition is satisfied ,So It
will give all data which is present in table.
Is This Answer Correct ? | 23 Yes | 1 No |
Answer / jerry joseph
a. select * from Emp where null = null;
null = null will be always false.. so no rows returned..
change the query to "select * from Emp where null is null;"
to select all rows
b. select * from Emp where 1=1;
1 = 1 will be always true.. so all the rows are returned..
Is This Answer Correct ? | 17 Yes | 1 No |
Answer / anil patel
a. select * from Emp where null = null;
null= null is always false os no rows returns.
b. select * from Emp where 1=1;
it returns all rows
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / gowthami radhakrishnan
a)in the first case there is no output only the column
names alone is displyed
b)in this case all rows will be displayed even for
1=1,2=2,3=3,..........
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / radhakrishnan
a) first statement return only table structure (with out
data)
Eg: empid empname
b) second statement return the structure with data.
Eg: empid empname
101 radha
102 krishnan
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sailaja
Hi,
select * from EMP where null=null;
->null=null is always false so it gives 0 records.
if it is null is null then it fetches all the records in a
table..
select * from EMP where 1=1;
->it fetches all the records in a table
if it is select * from EMP where 1=2;
-->it fetches 0 records..
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / m@ngesh
in the first query There is no records to show in output
box only show the column name Like empname, city, address
etc..
and the second query say that there is all records are to
be show.when query (1=1) will be satisfied on the table
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / nitin yadav(9229430059)
A. Will give you no record because null have no value that
means no comparision between two nulls.
B.will give all row because 1=1 condision always true for
all rows.
Is This Answer Correct ? | 0 Yes | 0 No |
How to Rebuild Master database in sql server 2005.
What functions can a view be used to performed?
What is a transaction and what are ACID properties?
can any body tell me how to know the password of current user in sql server
What is normalization of database?
What is indexing a document?
What is clustered index
what are the Prerequisites for Replication?
What is the use of “join” in sql server?
How to write a query with a left outer join in ms sql server?
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product
What is the difference between a Application Server and a Database