473,325 Members | 2,771 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

can u tell me this sql querry

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
Jan 27 '09 #1
4 1639
debasisdas
8,127 Expert 4TB
try to use MINUS and rowid for the purpose.
Jan 27 '09 #2
can u please help me with this querry further,
Jan 27 '09 #3
delete from emp
where rowid not in ( select rowid from emp minus select rowid from emp where rownum between 70 and100);
Jan 27 '09 #4
thanks anyways for this help
Jan 27 '09 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Eric Kincl | last post by:
Hello, I have an array of data in PHP. I would like to insert each member of the array into it's own row in SQL. The array is of variable length, so it would have to be dynamic code. How would...
17
by: Paul | last post by:
HI! I get an error with this code. <SCRIPT language="JavaScript"> If (ifp==""){ ifp="default.htm"} //--></SCRIPT> Basicly I want my iframe to have a default page if the user enters in...
2
by: Brian Paul via AccessMonster.com | last post by:
I have never did a word merge from access, However reading through these threads I think has confused me. Posted on Microsoft Access site, No answer, so Im thinking might not be able to do it. ...
7
by: mohan | last post by:
Hi i am new to this group.Kindly send me the C language code that can open and play a player(mp3 etc)
1
by: dbull4 | last post by:
HI I am trying to write a count querry where we can count the ratings on a school report. IE How many students in a year level got A's, B's C's etc. I have a rating table and use combo boxes to enter...
1
by: saddist | last post by:
Hello, TRAININGS(ID_TRAINING, TRAINING_NAME) HOSTED_TRAININGS(ID_HOSTED_TRAINING, ID_TRAINING, DAYS) EMPLOYEES_ON_TRAININGS(ID_HOSTED_TRAINING) What I want to do is a querry with sum of days...
0
by: getmeidea | last post by:
I have the following tables, 1> employee_master(emp_id int primary key, emp_name varchar(100)); 2> employee_salary_payment(salary_rid int primary key, emp_id int, sal_date date, paid_amt int); ...
3
by: avi25b | last post by:
Respected Sir, I run once sql querry in sql 2000 but show error. pls give me soluction now. SELECT a.BILL_DATE, COUNT (DISTINCT a.bill_number + ' ' + a.bill_date + ' ' +...
17
by: mmaserati | last post by:
I need to make multiple queries and the second and third rely on data retrieved from the first one. The 1st one finds a user in a table. If the user is there then we go on. However if they are not...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.