Why does this query return 0?



Why does this query return 0?..

Answer / Renu Kohli

There are several reasons why a query might return 0 results, but without the actual query it's impossible to know for sure. Some common reasons include:n
1. No matching records in the table.
2. Empty tables.
3. Incorrect JOIN or WHERE clauses resulting in no matches.
4. Missing data due to truncation errors.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Development Interview Questions

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

1 Answers   IBM,


I have a few records all are same structures data, I want to store data in multiple targets how

1 Answers   CTR, Infosys, Polaris,


Explain about a primary key?

1 Answers  


Explain about xml databases?

1 Answers  


what is difference between primary key and unique key ?

2 Answers  


What are triggers? How many triggers you can have on a table?

2 Answers   Ramco,


Explain about the relational database?

1 Answers  


Explain about the database management systems.

1 Answers  


What is dbms explain in brief?

1 Answers  


What are the main phases of database development?

1 Answers  


Given an employee table, how would you find out the second highest salary?

9 Answers  


How would you design a database for an online site, which would average a million hits a day?

1 Answers  


Categories