How to retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000
10 13094Source 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.
CGI,
5 6988Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
1550Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
TCS,
2056What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual
6 17718What are the steps you take to tune(performance tuning) the code in plsql?
Cap Gemini, Infosys, TCS,
4 16023
What is optimistic concurrency control? : Transact sql
Why we use stored procedure instead of query?
What is difference between stored procedures and application procedures?
how can we submit a form without a submit button? : Sql dba
How many types of triggers exist in pl/sql?
Explain foreign key in sql?
Which operator is used in query for pattern matching?
what is oltp (online transaction processing)? : Sql dba
what is the difference between join and union? : Sql dba
What is dense_rank?
What is the difference between python and sql?
Explain unique key in sql.
Why do we create views in sql?
What are the different dml commands in sql?
What is primary key and foreign key?