Write a query to find five highest salaries from EMP table. (there is a column SALARY)

24 Answers   Cap Gemini, iNautix,

---

What are two statement types in sql?

0 Answers  

---

Does group by remove duplicates?

0 Answers  

---

What are character functions in sql?

0 Answers  

---

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

0 Answers  

---

Which language is used in sql?

0 Answers  

---

What are inbuilt functions in sql?

0 Answers  

---

Does truncate remove indexes?

0 Answers  

---

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

---

source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?

4 Answers   JPMorgan Chase,

---

Explain the concept of normalization.

3 Answers  

---

i don't want the message as 14 rows updated just it should update what it will do

4 Answers  

---