what is the output for this query
select * from employee where 1=1;
Answer Posted / mohanakrishna
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 ? | 5 Yes | 1 No |
Post New Answer View All Answers
what are user defined datatypes? : Sql server database administration
What are the restrictions that views have to follow?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
What are cursors and when they are useful?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is the default server name for sql server?
What is meant by dirty read?
What is tcl in sql server?
Explain ranking functions?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
How to create stored procedures with parameters in ms sql server?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
What is role playing dimension with two examples? : sql server analysis services, ssas
What is the main difference between ‘between’ and ‘in’ condition operators?
How do we synchronize On-Premise SQL server with SQL Azure?