How does propagation differ between Advanced Replication and
Snapshot Replication (read-only)?
No Answer is Posted For this Question
Be the First to Post Answer
How are Indexes Update ?
What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How to create a stored procedure in oracle?
find out the third highest salary?
92 Answers CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,
How to list all indexes in your schema?
How do you rate yourself in oracle and sql server ?
What is meant by joins? List out the types of joins.
What is the relation of a user account and a schema?
How do I limit the number of rows returned by an oracle query after ordering?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?