Answer / hannan oca

by using order by asc or order by des;

we can sort the data.

Answer / satish asnani

For EMP table
order by deptno asc OR order by deptno desc

Normally records with NULL values are listed at last. We can
change this by using "NULLS FIRST" or "NULLS LAST" along
with order by clause.

Ex: order by deptno nulls first

Answer / slokh

SELECT * FROM table_name
ORDER BY column_name ASC;

What are code pages ?

1 Answers   BirlaSoft,

---

What is difference between sql and excel?

0 Answers  

---

will function return more than one value how

9 Answers   Accenture,

---

Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin

5 Answers   Deloitte, Ness Technologies,

---

What is basic structure of pl sql?

0 Answers  

---

Does a primary key have to be a number?

0 Answers  

---

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

---

Is crud a cuss word?

0 Answers  

---

What is the purpose of a secondary key?

0 Answers  

---

If a View on a single base table is manipulated will the changes be reflected on the base table?

5 Answers  

---

What is exception? What are the types of exceptions?

0 Answers  

---

What will you get by the cursor attribute sql%rowcount?

0 Answers  

---