How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

4 Answers   Credit Suisse, GCU, Symphony, TCS,

---

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

17 Answers   HCL, IBM,

---

What is use of except clause?

0 Answers  

---

which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM

5 Answers   Wipro,

---

If user is owning any SQL Objects, can we drop that user

0 Answers  

---

What is the difference between upgrade and migration in sql server?

0 Answers  

---

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

0 Answers  

---

What part does database design plays a role in performance of an sql server-based application?

0 Answers  

---

I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 Answers  

---

What is the parse query button used for?

0 Answers  

---

What is a trigger and types of a trigger?

0 Answers  

---

What are the different types of Indexes available in SQL Server?

0 Answers  

---