• Courses
  • Code Compiler
  • Discuss
  • Pricing
  • Teams
Menu
0

How can we find highest salary in employee table

hhh

sql
13th Nov 2017, 10:07 AM
Narsa reddy
Narsa reddy - avatar
6 Answers
+ 8
http://www.programmerinterview.com/index.php/database-sql/find-nth-highest-salary-sql/amp/
13th Nov 2017, 10:27 AM
qwerty
qwerty - avatar
+ 6
select max(salary) as salary from table; This query will get the maximum salary assuming the table contains a salary column
13th Nov 2017, 10:29 AM
Mohammed Hany
Mohammed Hany - avatar

Often have questions like this?

Learn more efficiently, for free:

  • Introduction to Python

    7.1M learners

  • Introduction to Java

    4.7M learners

  • Introduction to C

    1.5M learners

  • Introduction to HTML

    7.5M learners

See all courses
Hot today
How do we code calculator
2 Votes
What programming language should i learn to make applications or games?
0 Votes
I need help
1 Votes
My hearts are disappering :(
0 Votes
How to learn python fast than usual in sololearn?
0 Votes
What can html, css and javascript do
0 Votes
Pressure and tension
2 Votes
How to make a selection on a calculator in Python
0 Votes
ConducciĂłn de calor o Q=−kAdTdxQ = -k A \frac{dT}{dx}Q=−kAdxdT o Pared 2 mÂČ, espesor 0.1 m, k = 50 W/m°C, ΔT = 30°C → Q ≈ 30,0
0 Votes
Where is code bit
0 Votes