Answer Posted / raman sharma

For third highest salary u can use this syntax

select min(cin) from ( select distinct cin from
cws.usertable order by cin desc ) where rownum<4

What are logical database components? : SQL Server Architecture

1038

---

What is a system database and what is a user database?

1087

---

Explain the etl (extraction, transformation, and loading)?

996

---

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

1015

---

Explain different types of Normalization.

1835

---

What is apply operator in sql?

1013

---

What is Service Broker in sql server 2012?

1021

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

1519

---

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1022

---

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1683

---

Explain various data region available in ssrs with their use?

934

---

Relational calculus is what type of language?

1037

---

What are the advantages of user-defined functions over stored procedures in sql server?

1044

---

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1966

---

Why we use functions in sql server?

1080

---