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 is primary key in db?

0 Answers  

---

What is rank function in sql?

0 Answers  

---

What is the difference between rename and alias?

0 Answers  

---

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,

---

what are the 'mysql' command line options? : Sql dba

0 Answers  

---

what are myisam tables? : Sql dba

0 Answers  

---

Is primary key always clustered index?

0 Answers  

---

What is the difference between execution of triggers and stored procedures?

0 Answers  

---

What is meant by cursor in sql?

0 Answers  

---

How to create your own reports in sql developer?

0 Answers  

---

Can there be more than one function with a similar name in a pl/sql block?

0 Answers  

---

What is primary key sql?

0 Answers  

---