0
How can you get the 3rd highest salary in SQL from employee database?
Wiki User
∙ 14y ago
select * from ( select eno, ename, sal, rank() over(order by sal desc) rnk ) where rnk = 3
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
How does normalization reduce data redundancy?
Normalization is being applied for the database to reduce redundancy as in case of first normal for remove the redundant data from rows and in 2nd normal form it removes the redundant data vertically and in 3rd normal form it looks for the redundant data and whether it is non transitively depend on the primary key or not in other words it is the technique of breaking down the complex table into understandable smaller one to improve the optimization of the database structure and data redundancy is the data organization issue that allows the unnecessary duplication of data within the database. For example the first normal form where there should be one key in every table to uniquely each row thus no rows should be repeated and each entry must contain a single value and not multiple values .for instance employee, employee name, telephone numbers.
How do you use a box and whisker plot?
Box and whisker plots are used to give a visual indication of where quartiles and highest/lowest values fall, so they're useful for visually comparing various sets of data. The "whisker" on the left extends to the lowest value in the data range (the left-most point). The first edge of the "box" indicates the lower quartile, the middle line in the box represents the median quartile, and the upper edge of the box represents the 3rd quartile. The "whisker" on the right extends to the highest value in the data set. Clearly when using many box and whisker plots, and comparing them to each other, it helps greatly if you use the same scale on each plot. Sometimes it may be decided that your lowest/highest data values are "outliers" (anomalous results), in which case they are still included in the box and whisker plot, but they should be demarcated by a hollow circle wherever the outlier is deemed to be.
Whats a phenomenon about which competent observers can agree?
law (as in newton's 3rd law)
Can a pie chart represent who will go 1st 2nd 3rd or 4th in sequence?
No, but it can represent the probability of such an outcome.
Which sequence of numbers represents the number of segments the Cantor Dust fractal has after the 1st 2nd and 3rd iterations?
2,4,8
What country has the highest wages?
US has the highest average salary; however, Great Britain and Japan have the highest per capita salary with the US 3rd. Note: as of 2010 Canada is actually the highest median PPP houshold income after taxes, Switzerland 2nd and US 3rd
How much is the Salary in a fashion magazine?
Salary for doing what? President of the company, or 3rd basement janitor?
How much does a 3rd grade teacher make?
The average salary of a 3rd grade teacher is $53,000 per year. The average salary of a math teacher is $38,211 per year.
What has Malaysia got the third highest number of?
Malaysia has the 3rd highest number of what?
What is the 3rd highest mountain in the world?
Kanchenjunga
How serious is a felony c?
its the 3rd highest felony you can get think for a second A B C, A is the highest.
What state has the 3rd highest population in Australia?
The state with the third highest population in Australia is Queensland.
What is 3rd highest bread consuming country?
Its Romania
What is the salary of 3RD officer in wallem ship management hongkong?
2200 USD
What is the average salary in Texas for software developers?
the average salary for a software designer is 75k a year in texas, Which is the 5th lowest average salary for this job position. In Brisbane California the lowest average Salary for a software designer is 113k a year. Which is the 3rd lowest salary for this position yet is is a livable salary for Brisbane California.
What is the 3rd highest Score in basketball for 1 team?
The Nets
What is the salary for Tim flannery 3rd base coach for the San Francisco Giants?
$500,000
