Answer Posted / santosh kumar

select Top 1 salary from ( select top 2 salary from
emp_table order by salary desc)temptable order by salary
asc.

Is a primary key unique?

989

---

How to create new table with "create table" statements?

1093

---

when you create a database how is it stored? : Sql server database administration

1018

---

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

969

---

Define right outer join in sql server joins?

1042

---

Is sql server implemented as a service or an application? : Sql server database administration

961

---

Explain what is raid and what are different types of raid levels?

1019

---

Explain about builtinadministrator?

1049

---

What is an index in sql?

999

---

Explain Geography datatype in SQL Server

1127

---

What is normalization? Describe its different types.

1103

---

How to provide column names in insert statements in ms sql server?

1150

---

What are temporal tables in sql server 2016?

881

---

Write down the syntax and an example for create, rename and delete index?

980

---

How to choose all records from the table?

1063

---