Question

$\huge{\tt{Ello!!}}$
Write a query to display the name, job title and salary of employee who don't have manager....#SQL (computer science)​

Answer 1

$\huge{\overline{\underline{\bf{\mid{Answer}\mid}}}}$

$\texttt{my sql>SELECT name, job title,salary,manager}$

$\texttt{-> WHERE (NOT manager=' ')}$

$\texttt{-> FROM tablename ;}$

${\bullet{\underline{\textbf{Related information:-}}}}$

SQL:-

It stands for structured query language developed in 1970s in an IBM laboratory. 4th generation non procedural language.

Database:-

It is a data structure that stores organized information. Most database contain multiple tables, which may include several different fields. By storing data can be easily searched, stored and updated.

Answer 2

Write a query to display the name, job title and salary of employee who don't have manager ?

ANSwEr :

》Select Name, Job title, Salary from Employee,

Where ( NOT Manager = ' ')