Showing posts with the label SQLShow all
SQL
How to find nth highest salary
Table name : Emloyee_Highest_Salary select * from Emloyee_Highest_Salary See the max and min salary of Employee Here Top 3 salary in descending ord…
Read more
SQL
Inner Join
Inner Join:👉 Inner Join is used to fetch the marching data from both table. OR 👇 INNER JOIN statement returns only those records or rows that …
Read more
SQL
SQL
Stored procedure with an output parameter
A Stored procedure with an output parameter Table name : [dbo].[Test_EmployeeTbl] 👉select * from [dbo].[Test_EmployeeTbl] CREATE TAB…
Read more
SQL
Seeing the text of SP. SP_helptext
Seeing the text of SP. SP_helptext Syntax: 👉 Sp_helptext ProcedureName Query 👉 Sp_helptext SpGetEmployeeByIdAndName CREATE proc…
Read more
Social Plugin