Interested to Buy Any Domain ? << Click Here >> for more details...
You 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?
- 0 Answers
- 1118 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
How you can make a parameterized view?
How to customize error conditions.
Which four data types cannot be used as a return type from a user-defined function?
What is a join and explain different types of joins?
What is data modeling with example?
Explain about network model?
Who are end users in dbms?
Explain about post-relational databases?
What is normalization? Explain different levels of normalization?
8 Answers CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,
You 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?
What is the system function to get the current user's user id?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
