If a column is an image value type, how you can compare column values? How can you use this column in join clause?
592You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
592You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
547The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
576What are the three basic rules which are to be followed for the relational model of the database?
563Post New DB Development Questions
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
How you can make a parameterized view?
What is dbms explain in brief?
Explain about relational operator join?
How can you log an error to the server event log from a stored procedure?
What are the three types of database design?
What are the key features of dbms?
How to replace not in with not exist?
Explain the cube operator?
What are data modelling techniques?
How can I detect whether a given connection is blocked?
How can you fix a poorly performing query?
I have a few records all are same structures data, I want to store data in multiple targets how
Explain about relational database management systems?
What is dbms and its application?