Write a query to find second highest salary of an employee.

27 Answers  

---

Does access use sql?

0 Answers  

---

How can get second highest salary in sql?

0 Answers  

---

what is union? : Sql dba

0 Answers  

---

what is the command used to fetch first 5 characters of the string? : Sql dba

0 Answers  

---

Explain what is table in a database?

0 Answers  

---

which operator is used in query for pattern matching? : Sql dba

0 Answers  

---

What is sql performance tuning?

0 Answers  

---

Hi All, I am new to both this blog and technology. I was able to see a response for one of the questions on triggers as below. I would like to know why are we using " if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then" instead, can't we use " if sysdate = 'sunday' then". I can understand the use of "rtrim", but dont know y v r using to_char. I have seen this in many cases but did not get a convincible explaination. Please help me with this and do excuse if this question sounds silly. Thanks in advance...... create or replace trigger trg_sun before insert on <table name> begin if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then raise_application_error(-20345,'no transaction in sunday'); end if; end trg_sun;

2 Answers  

---

What is clustered index in sql?

0 Answers  

---

What is data profiling in sql?

0 Answers  

---

Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

---