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;

How much ram can sql express use?

0 Answers  

---

Is left join faster than inner join?

0 Answers  

---

What is cursor explain with example?

0 Answers  

---

How long it takes to learn pl sql?

0 Answers  

---

what is the different between unique+not null & primary key,

4 Answers  

---

what is the difference between blob and text? : Sql dba

0 Answers  

---

function can return multiple value?how give give sample coding

2 Answers   3i Infotech, CTS, Excelity Global, UHG,

---

Does a join table need a primary key?

0 Answers  

---

What is #table in sql?

0 Answers  

---

write sub query for eliminating duplicate rows using analytical function?

3 Answers   Metric Stream,

---

Does normalization improve performance?

0 Answers  

---

Is like operator in sql case sensitive?

0 Answers  

---