Horje
how to get employee having maximum experience in mysql Code Example
how to get employee having maximum experience in mysql 
select max(salary), dept_id from employee where salary not in(select max(salary) from employee) group by dept_id;
Source: www.codeproject.com



Sql

Related
database passwords from dbeaver Code Example database passwords from dbeaver Code Example
create table using the clause with as Code Example create table using the clause with as Code Example
psql store procedure-return multiple table values Code Example psql store procedure-return multiple table values Code Example
psql create usr Code Example psql create usr Code Example
test connection to sql server Code Example test connection to sql server Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 8



 

Horje