| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to work on DTS?what is the main requirement? | ivan | 1 |
| In performance wise distinct is good or group by is good?
eg:select name from emp group by name;
select distinct name from emp; | Infosys | 4 |
| please can anyone answer this query
Table 1 has 2 columns: EmployeeId,Age
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region who has the oldest person | | 7 |
| How to Get the last identity value used | | 4 |
| How will u get 5 years back record? | | 4 |
| What is a job? | | 3 |
| What is data integrity? Explain constraints? | Thinksoft | 1 |
| How to Run a Query on a Remote SQL Server? | | 2 |
| what is Archive old data? | | 1 |
| How to find the date and time of last updated table?
| Teledata | 4 |
| Following are some of the question related to below
mentioned query?
select e1.salary from employee3 e1
where 2=
(
select count(distinct(e2.salary))
from employee3 e2 where e2.salary>=e1.salary
)
1) What the query returns?
2) How it works? - Detail explanation (what the sub query
does, why it is (where 2=)....etc...Please?
| | 3 |
| Hi Can any one tell me the Good institute to learn SQL esp
for Data Base Testing or SQL from scratch to the
proficiency level in Hyederabad and facult also. Thankyou
well in advance | | 6 |
| event classes in sql server | Accenture | 1 |
| Anyone please explain me the concept of Serialization? | | 3 |
| Explain basic SQL queries with SELECT from where Order By,
Group By-Having? | Wipro | 2 |
| WHAT IS DIFFRENCE BETWEEN TRUNCATE AND DELETE STATEMENT | CTS | 10 |
| What should we do to copy the tables, schema and views from
one SQL Server to another? | | 3 |
| write the query for taking database backup in sql | Logica-CMG | 6 |
| Which command using Query Analyzer will give you the version
of SQL server and operating system? | | 3 |
| can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com | Symphony | 21 |
| |
| 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
