Learn Sql server in hindi/urdu part-10 (Like and WildCards in sql Server)

select  *from employee



  insert into employee values('Abid',15000,1)





  select * from employee where emp_name like 'A%'



  select * from employee where emp_name like '%a'



  select * from employee where emp_name like '%a%n'



  select * from employee where emp_name like '__n%'



  select * from employee where emp_name like  's_%'



  select * from employee where emp_name like  's%a'

Learn Sql server in hindi/urdu part-9 (Sum ,Top and Subquery on differen...

 select * from employee

  select * from department





  --display top 3 records from employee table.

  select top 2 * from employee  where emp_id < (select max(emp_id) from employee)  order by emp_salary desc





  select * from employee order by emp_salary asc





  --dispaly sum of salary of those employees who are working in Marketing department



  select sum(emp_salary) from employee e inner join department d on d.dept_id=e.dem_deptid

  where d.dept_name='Marketing'







  --display top 5 records of employees  who are working in Hr and Marketing

  select top 5 * from employee e inner join department d on d.dept_id=e.dem_deptid

  where d.dept_name='Marketing' or d.dept_name='Hr'

Learn Sql server in hindi/urdu part-8 Aggregate function with inner joi...

use sql1707b1





select * from sys.tables



select * from employee

select * from department





--display maximum salary from employee table

select max(emp_salary)from employee





--display minimum salary from employee table

select min(emp_salary) from employee





--display avg salary from employee table



select avg(emp_salary) from employee





--display no.of employees record from employee table

select count(emp_id) from employee







--display, how many employees are working in Hr Department with salary >10000



 select count(e.emp_id) from employee e inner join

  department d on d.dept_id=e.dem_deptid where e.emp_salary>10000 and d.dept_name='HR'



;