Trending Oracle SQL Discussions

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:

18

Views:

43

Vote Count:

1

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

Answers:

34

Followers:

34

Views:

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‎ ... See More

Answers:

34

Followers:

35

Views:

104

Vote Count:

0

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

Answers:

2

Followers:

2

Views:

190

Vote Count:

0

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

Answers:

17

Followers:

17

Views:

253

Vote Count:

0

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

Answers:

20

Followers:

20

Views:

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

Answers:

1

Followers:

2

Views:

243

Vote Count:

0

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

Answers:

32

Followers:

31

Views:

614

Vote Count:

0

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

Answers:

30

Followers:

31

Views:

1137

Vote Count:

0

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

Answers:

2

Followers:

2

Views:

76

Vote Count:

0