My sql statement select avg(salary) from emp yields inaccurate results. Why?
No Answer is Posted For this Question
Be the First to Post Answer
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
What is meant by the attachment facility?
What is a recovery log?
What is the use of predicate?
How many Buffer pools are there in DB2 and what are they?
How does the processing of a correlated subquery differ from a non correlated subquery?
What is a DB2 bind?
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
What is dbrm library?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
What is a synonym ?