| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| write query for fourth maximum salary from employee table | Mind-Tree | 5 |
| how to change column into row in sql | ESS | 2 |
| How will u get 5 years back record? | | 4 |
| wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records | | 16 |
| how to give input dynamically to a insert statement in
sqlserver | HCL | 2 |
| how insert selected column only ? | Robert-Half | 2 |
| what is web server?
| Satyam | 3 |
| What is a transaction and what are ACID properties? | IBM | 4 |
| I have to display ten columns values from diffrent ten
tables.
how many joins are require? | HCL | 8 |
| WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE
RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,... | TVS | 2 |
| What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance.... | Siemens | 6 |
| how we can count records as a group of days like sum of
records for(four mondays),(four tuesday)........ in a month.
group the column for weekdays.
| | 1 |
| Can I know,how to Execute Funcion and Trigger through
command(Manualy Execution) in MS SQL/SERVER 2005,give me
answer with Example. | | 1 |
| What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table | HP | 15 |
| Differnce between sel server 2000 and 2005 | | 3 |
| What is an index? | Yardi-Software | 7 |
| what is the importence of the trigger in sqlserver2000? | ATI | 1 |
| explain different types of jions with examples briefly? | Zensar | 2 |
| I have a website that allows customers to browse and place
orders for certain products.
I have 2 tables; Customers and Orders. The Customers table
holds the customer records and the Orders table
holds the orders placed by the customer. Both tables are
tied based on the field Cust_ID.
Example of the data is shown below:
Cust_ID Cust_Name Cust_ID Product Amount Order_Date
1001 John Tan 1001 P-5211 $120.00 2/13/2006
1002 Michael Wong 1001 K-1428 $88.90 1/11/2006
1003 Mary Cheong 1003 C-0923 $82.50 1/27/2006
1004 Ahmad Suffian 1003 K-1428 $88.90 2/2/2006
Write a single SQL statement that extracts all purchase
records with the following criteria:
1. Customer names starting with “M” only.
2. Orders placed within the current month only.
3. Amount does not exceed $100.00
The list must be sorted by order date with the latest order
showing on top. | Techno-Solutions | 3 |
| What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE? | Yardi-Software | 4 |
| |
| For more SQL Server Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
