Answer Posted / sysdomain

'top' will fetch only top most : ie top 5 means it will
fetch first 5 rec. After fetching rec only 'order by' is
done ie sorting is done after fetching. therefore using
'top' and 'order by' alone wont get max or min value. for
that we have to use 'distinct' before 'top' along with
'order by' (which will sort
the records before fetching).

select top 1 salary from employee where salary in (select
distinct
top n salary from employee order by salary desc)

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

940

---

What are the difference between primary keys and foreign keys?

915

---

What is a dbms wizard?

971

---

What is isolation levels?

965

---

Explain steps of normalization?

944

---

What are diverse clauses that form a part of sql?

1018

---

What do you mean by tablesample?

1035

---

When I delete any data from a table, does the sql server reduce the size of that table?

959

---

Tell me the use of keyword with encryption. Create a store procedure with encryption?

963

---

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1034

---

Does sql server 2000 full-text search support clustering?

816

---

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2163

---

Which is better statement or preparedstatement?

870

---

Why use sub query in sql server and list out types of sub queries?

940

---

How to create a view using data from another view?

905

---