Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > oracle > answers

can u tell me this sql querry

Newbie
  
Join Date: Jan 2009
Location: delhi
Posts: 4
#1: Jan 27 '09
hello can anybody help me

if there is a table named emp and there are 100 rows in this table and we like to delete 30 rows from the bottom .can any body help me with this SQL querry
debasisdas's Avatar
Moderator
  
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,500
#2: Jan 27 '09

re: can u tell me this sql querry

try to use MINUS and rowid for the purpose.
Newbie
  
Join Date: Jan 2009
Location: delhi
Posts: 4
#3: Jan 27 '09

re: can u tell me this sql querry

can u please help me with this querry further,
Newbie
  
Join Date: Jan 2009
Location: delhi
Posts: 4
#4: Jan 27 '09

re: can u tell me this sql querry

delete from emp
where rowid not in ( select rowid from emp minus select rowid from emp where rownum between 70 and100);
Newbie
  
Join Date: Jan 2009
Location: delhi
Posts: 4
#5: Jan 27 '09

re: can u tell me this sql querry

thanks anyways for this help
Reply

« previous question | next question »

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,272 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved