Answer Posted / sikindar

select * from emp where sal=(
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal));

What is difference between line feed ( ) and carriage return ( )?

855

---

Write SQL queries on Self Join and Inner Join.

1072

---

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1891

---

explain what is raid and what are different types of raid configurations? : Sql server database administration

951

---

what are the disadvantages of cursors? : Sql server database administration

974

---

What is database isolation in sql server? : sql server database administration

1025

---

What is an identity column in insert statements?

970

---

How do I find the sql server instance name?

922

---

What is data source document?

980

---

What is catalog views?

1025

---

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

847

---

How do I trace a query in sql server?

903

---

What is the latest version of microsoft sql server?

970

---

Which tools are available to manage SQL Azure databases and servers?

113

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

905

---