Does a join table need a primary key?


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

Post New Answer

More SQL PLSQL Interview Questions

HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)

8 Answers   BeBo Technologies,


Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,


What is sql injection owasp?

0 Answers  


What is faster join or subquery?

0 Answers  


Types of optimization?

6 Answers   Microsoft,






in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 Answers  


Why left join is used in sql?

0 Answers  


Why do we create stored procedures & functions in pl/sql and how are they different?

0 Answers  


What are the modes of parameters that can be passed to a procedure ?

3 Answers  


How to count the no of records of a table without using COUNT function?

11 Answers   TCS, Tesco,


what are all the common sql function? : Sql dba

0 Answers  


What is compound trigger?

0 Answers  


Categories