10 Important SQL Server Interview Question and Answer
SQL Server Important Interview Question and Answers:
1. Write a query to fetch 50% records from the SQL Server table.
2. Write a SQL query to find the position of the alphabet
3. Write a query in SQL to find max, min and average salary of employee.
4. Write a SQL query to fetch only first name from column full name (String before space) from table employee.
5. Write a SQL query to find the total occurrence of a particular Character - 'a' 6. Write a SQL query to fetch duplicate records from employee table (leaving 7. How to identify all stored procedures referring a particular table.
8. How to find the no of columns in a particular table.
9. Write query in SQL Server to find running Salary from table employee
10. Count Total rows from SQL table without using aggregate function Count.
SQL Question Answer for Freshers: • Question1- SQl Query to Get all Disti...
SQl Query to Get all Distinct Value Comma Separated: • Question1- SQl Query to Get all Disti...
Query in SQL SERVER to GET Nth highest Salary: • Question3 - SQL SERVER Query to GET N...
DELETE DUPLICATE RECORDS FROM SQL SERVER TABLE: • Question11 - SQL SERVER HOW TO DELETE...
jQuery Tutorial in Hindi: • jQuery Complete Course For Beginners ...
How to write complex sql query: • How to write complex query in sql ser...