Search
 
SCRIPT & CODE EXAMPLE
 

SQL

max 3 salary in sql

SELECT salary, first_name, last_name FROM employees
ORDER BY salary DESC LIMIT 3;
Comment

first max salary in sql

SELECT first-name
FROM employees
WHERE salary = (SELECT MAX(salary) FROM employees);
Comment

PREVIOUS NEXT
Code Example
Sql :: how to find first 3 highest salary in sql 
Sql :: SQL Syntax of INNER JOIN 
Sql :: insert multiple rows from another table sql 
Sql :: sql numeric data type 
Sql :: carbon mysql d m y to y-m-d 
Sql :: t-sql never ending delete 
Sql :: sql float 3 decimal places 
Sql :: mysqkldump devilbox 
Sql :: get number of rows in every table mysql 
Sql :: openquery join two tables 
Sql :: delete and drop in sql 
Sql :: update field in sql to null 
Sql :: retrieve all data from a one row in mysql 
Sql :: remove decimal in sql server 
Sql :: postgres drop all tables 
Sql :: mysql show column type 
Sql :: sql track modification 
Sql :: mysql row generator 
Sql :: postgres insert timestamp without timezone 
Sql :: import mysql command line 
Sql :: sql server inner join 
Sql :: linq inner join 
Sql :: mysql workbench view 
Sql :: t sql first and last day of week 
Sql :: mysql select non integer values 
Sql :: alter table add multiple columns mysql 
Sql :: how to use join with 3 tables in sql server 
Sql :: sqlalchemy query join many to many 
Sql :: mysql order by list 
Sql :: insert set mysql 
ADD CONTENT
Topic
Content
Source link
Name
8+5 =