what is the output for this query select * from employee where 1=1;

Advertise your Business Here

Refer this Site

Login | Sign Up


	To Refer this Site to Your Friends Click Here

Categories >> Software >> Databases >> SQL Server

Oracle Interview Questions

SQL Server Interview Questions

MS Access Interview Questions

MySQL Interview Questions

Postgre Interview Questions

Sybase Interview Questions

DB Architecture Interview Questions

DB Administration Interview Questions

DB Development Interview Questions

SQL PLSQL Interview Questions

Databases AllOther Interview Questions

Question

what is the output for this query
select * from employee where 1=1;

Question Submitted By :: Om Namo Bhagavathe Vasudevaya

I also faced this Question!!

Rank

Answer Posted By

Re: what is the output for this query select * from employee where 1=1;

Answer
# 1

This Query will return all records from employee table.

Infact insteadof this query u can use " select * from employee ".Because the condition 1=1 is always true.It never become as false.

Both of the Queries are same..........

Is This Answer Correct ?

7 Yes

0 No

Soorai Ganesh

Re: what is the output for this query select * from employee where 1=1;

Answer
# 2

The querry display the total table information present in 
the database.

EID ENAME MID
 101 rama null
 102 sita 101 
103 siva 101 
104 ganesh 103

Is This Answer Correct ?

1 Yes

1 No

Mohanakrishna

Re: what is the output for this query select * from employee where 1=1;

Answer
# 3

Retriving all employee table records

Is This Answer Correct ?

0 Yes

1 No

Guest

Re: what is the output for this query select * from employee where 1=1;

Answer
# 4

here...retrieve all column and records of employee. and
there is condition 1 = 1 is always true if 1 value in any
column.

Is This Answer Correct ?

0 Yes

0 No

Amit Kumar

Question	Asked @	Answers
Other SQL Server Interview Questions


what operator performs pattern matching?		1
What are the new features in SQL Server 2005?	Emphasis	2
We create an index to fast the search. How it fast the query? Do we write any special keyword with query?		3
write the query for taking database restore in sql?		2
how insert selected column only ?	Robert-Half	2
WHAT OPERATOR PERFORMS PATTERN MATCHING?	CTS	2
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?		1
Hi..here i would like to know the Backup and Restore models?	HCL	2
write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?		7
how do u do Performance tunning ?	Satyam	1
Can Somebody tell me the difference between Clustered & Non- Clustered Index??	Progressive	3
How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?	Leo-Technologies	12
What are Sql Reporting Services and analysis services? Can u Explain		1
1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder	IBM	1
What is a trigger?		6
What are the four main query statements?		3
What is the difference between a Application Server and a Database	Oracle	2
What are cursors? Name four types of cursors and when each one would be applied?	Adea-Solutions	1
MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE	IBM	1
How to Check Whether a Global Temporary Exists in a SQL Database or not?		2

For more SQL Server Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com