Discussions Populaires Dans la Communauté Oracle SQL

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?‎

Réponses:

17

Adeptes:

18

Vues:

43

Vote Count:

1

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

Réponses:

34

Adeptes:

34

Vues:

99

Vote Count:

0

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‎ ... Voir Plus

Réponses:

34

Adeptes:

35

Vues:

104

Vote Count:

0

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

Réponses:

2

Adeptes:

2

Vues:

190

Vote Count:

0

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

Réponses:

17

Adeptes:

17

Vues:

253

Vote Count:

0

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

Réponses:

20

Adeptes:

20

Vues:

377

Vote Count:

0

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?‎

Réponses:

1

Adeptes:

2

Vues:

243

Vote Count:

0

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

Réponses:

32

Adeptes:

31

Vues:

614

Vote Count:

0

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

Réponses:

30

Adeptes:

31

Vues:

1137

Vote Count:

0

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

Réponses:

2

Adeptes:

2

Vues:

76

Vote Count:

0