Max sal to print base on manager_id

by

Possible would be a subselect inside the select (although a bit slow as all subselects are):

select id, mgr_id, sal, (select max(sal) from mytable n2 
where n2.mgr_id = mytable.mgr_id) as max_sal from mytable

More Related Contents:

  1. How to extrapolate dates in SQL Server to calculate the daily counts?
  2. Insert results of a stored procedure into a temporary table
  3. Best approach to remove time part of datetime in SQL Server
  4. Difference between JOIN and INNER JOIN
  5. Is there a way to access the “previous row” value in a SELECT statement?
  6. Remove Identity from a column in a table
  7. How to create multiple one to one’s
  8. efficient way to implement paging
  9. SQL Server – transactions roll back on error?
  10. Formatting Numbers by padding with leading zeros in SQL Server
  11. Difference between a User and a Login in SQL Server
  12. Convert Comma Separated column value to rows
  13. SQL Server : dynamic pivot over 5 columns
  14. For Nvarchar(Max) I am only getting 4000 characters in TSQL?
  15. Postgres Case Sensitivity
  16. How do I query for all dates greater than a certain date in SQL Server?
  17. Check If the string contains accented characters in SQL?
  18. Count based on condition in SQL Server
  19. What does sp_reset_connection do?
  20. Syntax of for-loop in SQL Server
  21. Replace first occurrence of substring in a string in SQL
  22. Why does ISNUMERIC(‘.’) return 1?
  23. How to correctly insert newline in nvarchar [duplicate]
  24. How do you copy a record in a SQL table but swap out the unique id of the new row?
  25. Using IF ELSE statement based on Count to execute different Insert statements
  26. How do I change db schema to dbo
  27. Is there a severe performance hit for using Foreign Keys in SQL Server?
  28. Sql Server : How to use an aggregate function like MAX in a WHERE clause
  29. Date serial in SQL?
  30. How to insert into a table with just one IDENTITY column?

Leave a Comment