Answer Posted / ashish

hi,, it work


select * from table where salary =(select max(salary) from
table) .......this returns whole record of that salary,,,,
an if u want just that maximum salary than



select max(salary) from table

Do you know hot add cpu in sql server 2008?

961

---

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1049

---

What is resource governor?

976

---

What is application role in sql server database security? : sql server security

1063

---

Write the SQL query to drop, truncate and delete table.

978

---

How will you hide an attribute? : sql server analysis services, ssas

964

---

What do you need to connect php to sql server?

1111

---

Does sql server 2016 have ssms?

965

---

what is normalization? : Sql server database administration

1102

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1152

---

What is data modeling and Reterminal integrity?

1959

---

How many partitions a clustered index has by default in sql server 2012?

1091

---

is there a column to which a default can't be bound? : Sql server database administration

1019

---

Does sql server 2000 clustering support load balancing?

980

---

Explain having clause?

972

---