Vamsikrishna Sudanagunta

• Nov 16th, 2022

Print first names and the last names of the artists who had zero sales or no sales?

Ekansh

• Jul 12th, 2022

Just add the ; in the end of quest :)

Answer Question  Select Best Answer

Bobby

• Apr 18th, 2018

Rowid is pseudo column and it can change internally especially on transactional table

himabindu

• Apr 16th, 2018

Why use rownum < 2?

Answer Question  Select Best Answer

Ayyappa

• Aug 24th, 2012

Hello leelakrishna302 ... Your query ...

Code
 
SELECT * FROM emp e 
WHERE rowid IN (SELECT max(rowid) FROM emp); 
 

gives only latest inserted records not the latest updated records..

leelakrishna302

 Profile Answers by leelakrishna302 Questions by leelakrishna302

• Jun 15th, 2012

Select * from emp e where rowid in( select max(rowid) from emp );

Answer Question  Select Best Answer

Vishal R Bhadange

• Aug 12th, 2012

Yes.
Yes we can truncate some of the rows from the table, But table should be partitioned & all the rows to be deleted should be present in one single partition...

leelakrishna302

 Profile Answers by leelakrishna302 Questions by leelakrishna302

• Jun 15th, 2012

We cannot

Answer Question  Select Best Answer

'' Should be used before '%'.

Nazeera Jaffar

• Oct 6th, 2012

The below code selects the column with a substring % (e.g.) reg%istration

Code
SELECT * FROM game WHERE name LIKE %\%% escape ;

Nazeera Jaffar

• Sep 30th, 2012

The below code will select the row having column as %

Code
SELECT * 
FROM table_name
WHERE column_name LIKE !%escape! 
 

Answer Question  Select Best Answer