How to find out Microsoft SQL Server Enterprise Edition Expiration Date
Introduction As you all know Microsoft SQL Server’s evaluation edition expires after 6 months of validity. So in this article, …
sqlserver
sqlserver
How can I remove duplicate rows from large table
Introduction Remove duplicate rows from large table which has more than 10,000+ rows. DELETE FROM student WHERE ID NOT IN …
Write a SQL query to get FirstName, Lastname, Scholarship amount from tblStudent and tblScholarship table for all students even if they didn’t get Scolarship
Introduction Write a SQL query to get FirstName, Lastname, Scholarship amount from tblStudent and tblScholarship table for all students even …
SQL Server Advanced Questions – ‘Join’
The following exercise will help you to improve your MS SQL server query skills effectively. I have used Microsoft SQL …
Write the query to get branch, no of students in a branch, total admission fees with respect to a branch from tblStudent table order by admission fees descending
Introduction Write the query to get branch, no of students in a branch, total admission fees with respect to a …
Write the query to get no of students joined with respect to year and month from tblStudent table
Introduction Write the query to get no of students joined with respect to year and month from tblStudent table. I …
Write the query to get branch wise average admission fees from “tblStudent” table order by admission fees ascending order
Introduction Write the query to get branch wise average admission fees from “tblStudent” table order by admission fees ascending order. …
Write the query to get the branch and branch wise total(sum) admission fees, display it in ascending order according to admission fees
Introduction Write the query to get the branch and branch wise total(sum) admission fees, display it in ascending order according …
Write a query to get how many students exist in tblstudent
Introduction Write a query to get how many students exist in tblstudent. I have used Microsoft SQL server 2008 R2 …
Write a query to get 5 % of admission fees from Michael, 10% of admission fees from John and for other 15 % of admission fees as ‘Deducted_Admission_fee’ from tblStudent table
Introduction Write a query to get 5 % of admission fees from Michael, 10% of admission fees from John and …