How can you fetch common records from two tables?


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

Post New Answer

More SQL PLSQL Interview Questions

what is d diff between grant,commit,rollback n savepoint

1 Answers  


What is mutating sql table?

0 Answers  


How does postgresql compare to "nosql"?

0 Answers  


Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  


Is foreign key mandatory?

0 Answers  






Does sql between include endpoints?

0 Answers  


Can we rollback truncate?

0 Answers  


How the execution will be done in exceptions?

2 Answers  


What is difference between left and right outer join?

0 Answers  


i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6

8 Answers   Satyam,


how to run 'mysql' commands from a batch file? : Sql dba

0 Answers  


Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,


Categories