define clustering index.
No Answer is Posted For this Question
Be the First to Post Answer
How do you eliminate duplicate values in db2?
What is rct?
Are views updatable ?
What is db2 bind?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
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
How to view db2 table structure?
How does coalesce work?
What is a collection?
What is image copy?
What is the role of data manager in the db2 database?
Explain the use of the WHERE clause.