How to avoid duplicate records in a query?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

What is an inconsistent dependency?

0 Answers  


What is sql select statement?

0 Answers  


Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers   CGI,


What are sql*plus environment variables?

0 Answers  


Can two tables have same primary key?

0 Answers  






what is the difference between a local and a global temporary table? : Sql dba

0 Answers  


What is the difference between left and left outer join?

0 Answers  


What is the result, when NULL is compared with NULL?

22 Answers   TCS,


How many rows can sqlite handle?

0 Answers  


ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

0 Answers   Wipro,


How to revise and re-run the last sql command?

0 Answers  


i want run a sql query query? which phases are run in a back ground? pls tell me the answer

1 Answers  


Categories