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?
No Answer is Posted For this Question
Be the First to Post Answer
Explain about query and reporting.
Explain about post-relational databases?
Which four data types cannot be used as a return type from a user-defined function?
How to replace not in with not exist?
what is the use of foreginkey
Explain the general syntax for a SELECT statements covering all the options.
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
Can you instantiate a COM object by using T-SQL?
What are the constraints on severity level in raiseerror?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
How to generate OIDS
Explain about the storage and physical database design?
Oracle (3259)
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)