Write a query to diplay product name whose assign many employee in product table.

Table Name: Emp

EmpId	Name
1	Sagar
2	Raj
3	Mohan
4	Anand
5	Tiku

Table Name:  Product

ProductId	EmpId	ProductName
1	1	Product1
2	1	Product2
3	2	Product3
4	3	Product4
5	5	Product5
6	3	Product6

select pp.proname,pp.proid,pp.empid from
(
select t.aaa,empid from
(
select count(proid)as aaa,empid  from product as p group by p.empid
) as t where t.aaa >= 2
) as t2 left join product as pp on t2.empid = pp.empid

Write a query to display employee name whose not assign any product table.

Table Name: Emp

EmpId	Name
1	Sagar
2	Raj
3	Mohan
4	Anand
5	Tiku

Table Name:  Product

ProductId	EmpId	ProductName
1	1	Product1
2	1	Product2
3	2	Product3
4	3	Product4
5	5	Product5

SELECT Empid, name FROM Emp e

WHERE NOT EXISTS

(

         SELECT * FROM Product AS p WHERE p.empid = e.empid

)

How to find second highest salary in SQL using TOP?

Table Name : SalaryDetails

ID	Salary
1	1000
2	500
3	750
4	500
5	350
6	750

SELECT TOP 1 salary FROM
(
             SELECT DISTINCT TOP 2 salary FROM SalaryDetails ORDER BY salary DESC
) a
ORDER BY salary asc

Difference between get and post method.

	GET (HTTP)	POST (HTTP)
History	Parameters remain in browser history because they are part of the URL	Parameters are not saved in browser history.
Bookmarked	Can be bookmarked.	Can not be bookmarked.
BACK button/re-submit behaviour	GET requests are re-executed but may not be re-submitted to server if the HTML is stored in the browser cache.	The browser usually alerts the user that data will need to be re-submitted.
Encoding type (enctype attribute)	application/x-www-form-urlencoded	multipart/form-data or application/x-www-form-urlencoded Use multipart encoding for binary data.
Parameters	can send but the parameter data is limited to what we can stuff into the request line (URL). Safest to use less than 2K of parameters, some servers handle up to 64K	Can send parameters, including uploading files, to the server.
Hacked	Easier to hack for script kiddies	More difficult to hack
Restrictions on form data type	Yes, only ASCII characters allowed.	No restrictions. Binary data is also allowed.
Security	GET is less secure compared to POST because data sent is part of the URL. So it's saved in browser history and server logs in plaintext.	POST is a little safer than GET because the parameters are not stored in browser history or inweb server logs.
Restrictions on form data length	Yes, since form data is in the URL and URL length is restricted. A safe URL length limit is often 2048 characters but varies by browser and web server.	No restrictions
Usability	GET method should not be used when sending passwords or other sensitive information.	POST method used when sending passwords or other sensitive information.
Visibility	GET method is visible to everyone (it will be displayed in the browser's address bar) and has limits on the amount of information to send.	POST method variables are not displayed in the URL.
Cached	Can be cached	Not cached