Bayt.com

Trending Informatica Discussions

Follow

Ask the Community


Ask any professional question and get answers from other specialists.

Stream language
SQL
Oracle SQL
Oracle
SQL Server
Database
mohamed khiry's image
Question added by mohamed khiry Senior Database Administrator confidential
6 years ago

If you have a table in your Database and there is a duplicate values in it How we can delete one raw of each duplicated rows?‎

Answers:
17
Followers:
Views:
43
Vote Count:
1
Report Inappropriate
Answer should contain a minimum of 25 characters.
Oracle SQL
Software
Database
Nidhi Goel's image
Question added by Nidhi Goel IOT Lead : Smart Meters DEWA
7 years ago

What is the difference between a dynamic and a static query in SQL? ‎

Answers:
34
Followers:
Views:
99
Vote Count:
0
Report Inappropriate
Answer should contain a minimum of 25 characters.
Web Development
Programming
SQL
Oracle SQL
SQL Plus
Balaji Prakash's image
Question added by Balaji Prakash Data Analyst Systech Solutions
7 years ago

How can i fetch duplicate data's from a table?‎

I completed my graduation last year and i am getting started with SQL. can anyone help me to solve this query.  Table name is Employee and it has the following fields EM‎ ... See More

Answers:
34
Followers:
Views:
104
Vote Count:
0
Report Inappropriate
Answer should contain a minimum of 25 characters.
Oracle SQL
Didarul Alam's image
Question added by Didarul Alam JR-Oracle Programmer Axiom Software Technologies Ltd.
7 years ago

How to call a report in oracle 10g form menu?‎

Answers:
2
Followers:
Views:
190
Vote Count:
0
Report Inappropriate
Answer should contain a minimum of 25 characters.
Oracle SQL
Oracle
Muhammad Shahid Farooq's image
Question added by Muhammad Shahid Farooq Software Engineer, System Integrator ForeVision Business Solutions
7 years ago

Write a query to find second highest salary of an employee?‎

Answers:
17
Followers:
Views:
253
Vote Count:
0
Report Inappropriate
Answer should contain a minimum of 25 characters.
Databases
Oracle SQL
Oracle
Backup
Database
mohamed khiry's image
Question added by mohamed khiry Senior Database Administrator confidential
8 years ago

What is the difference between [differential backup] and [incremental backup]? ‎

Answers:
20
Followers:
Views:
377
Vote Count:
0
Report Inappropriate
Answer should contain a minimum of 25 characters.
Oracle SQL
Kjell Bjerke's image
Question added by Kjell Bjerke
8 years ago

How to write a proper select on 3 tables (t1, t2 and t3). I need an outer join (+) between all 3, and I need to check for a constant in t2?‎

Answers:
1
Followers:
Views:
243
Vote Count:
0
Report Inappropriate
Answer should contain a minimum of 25 characters.
Web Development
Programming
SQL
Oracle SQL
Oracle Database
محمد حسام الدين حسن صدقى's image
Question added by محمد حسام الدين حسن صدقى Senior Functional Consultant Egabi Fsi
8 years ago

As Performance which is better? SQL Joins Or SQL Subqueries? and why?‎

Answers:
32
Followers:
Views:
614
Vote Count:
0
Report Inappropriate
Answer should contain a minimum of 25 characters.
Web Development
Computer Science
Oracle SQL
Oracle
Oracle Database
Manoranjan Hota's image
Question added by Manoranjan Hota Senior IT Analyst Veritas Corporation
8 years ago

What is the difference between Decode() and case in Oracle?‎

Answers:
30
Followers:
Views:
1137
Vote Count:
0
Report Inappropriate
Answer should contain a minimum of 25 characters.
Web Development
Programming
Oracle SQL
Qaisar Mushtaq's image
Question added by Qaisar Mushtaq Senior Consultant Systems Limitied
8 years ago

What is difference between Clusterd and non-clusterd index?‎

Answers:
2
Followers:
Views:
76
Vote Count:
0
Report Inappropriate
Answer should contain a minimum of 25 characters.