If you have a three columns table with one index on 2nd Column. In the SELECT statement you retrived column 1, can index be used or not?

amitsrivastava115

 Profile Answers by amitsrivastava115 Questions by amitsrivastava115

• Aug 2nd, 2011

Use index in the where clause , this way you can use it other wise not ...

geetha

• Jul 30th, 2011

Index will be used if the retrieval is based on an indexed column .if the where clause uses a column with index then the query will be executed based on that index.

Answer Question  Select Best Answer

How and in what way REPLACE is different from TRANSLATE?

zahar

 Profile Answers by zahar Questions by zahar

• Jun 10th, 2011

REPLACE : replace function is: replace( string1, string_to_replace, [ replacement_string ] )string1 is the string to replace a sequence of characters with another set of characters.string_to_repl...

sandip88

 Profile Answers by sandip88 Questions by sandip88

• Feb 9th, 2010

Translate does character by character substitution,where replace can substitute a singele character with a word

Answer Question  Select Best Answer

sandip.dhopat

 Profile Answers by sandip.dhopat Questions by sandip.dhopat

• Jun 9th, 2011

Select nth Row:select * from(select t1.c1, t1.c2, .... , rank(col_name) over (order by col_name) rnkfrom table_name t1)where rnk = n;To select top n rows in a order.select * from(select t1.c1, t1.c2, ...

p.mamta

 Profile Answers by p.mamta Questions by p.mamta

• Aug 30th, 2010

How to get the nth row from the table ?select distinct(Salary),* from Employee A where n=(select count(distinct(Salary)) from Employee b where b.Salary <= a.Salary);how to  select  first ...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

maverickwild  

 Profile Answers by maverickwild Questions by maverickwild

• Member Since Nov-2005 | Nov 15th, 2005

---

Try this

select sal from (select * from order by sal asc) where rownum < 3

snehal Falke

• Jul 13th, 2012

Select * FROM emp ORDER BY sal ASC LIMIT 2

mohit

• Jun 28th, 2012

If you want to employee name then query is given below

Code
SELECT ename,sal FROM (SELECT * FROM emp ORDER BY sal ASC)
WHERE rownum<=2;

Improve Answer