what is self join and why is it required? : Sql dba
Answer / suresh pagadala
Self join is nothing but the table performs join condition itself same table is called self join
Is This Answer Correct ? | 0 Yes | 0 No |
What is sp_helptext?
How do I count records in sql?
how to create a table index in mysql? : Sql dba
Where not exists in sql?
how to use in conditions? : Sql dba
How can I speed up sql query?
i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.
2 Answers IBM, Loginworks, OFSS,
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
Why function is used in sql?
How is data stored on a disk?
How global cursor can be declare with dynamic trigger ?
what is 'mysqld'? : Sql dba