Hi,
you will have to use either join or where for getting forth highest salary.
use nested query
select max(salary) from emp where salary<(select max(salary) from emp where salary<(select max(salary) from emp where salary<(select max(salary) from emp)))
use corrlated query
select * from emp e where 3=(select count(distinct sal) from emp x where x.sal>e.sal)
mcasaurabhsumit
Last Activity: Apr 27 '07, 06:18 PM
Joined: Feb 25 '07
Location:
-
differences between stored procedure and cursor
differences between stored procedure and cursor -
Here customerNo will be a primary key if u write it.
create table customers
(
customerNo int identity not null primary key,
customerName varchar(30) not null,
Address varchar(30),
contact varchar(25),
DateInSystem smalldatetime not null
)
now to make a composite key just put the primary key on two column.. When we set the constraint on two field to be primary key then...Leave a comment:
-
Write in this way and check the result:
Select paquet,product from paquet_product where product between 1 and 3 order by paquet...Leave a comment:
-
Differences between server.transfer and response.redirect?
hello frnd,
it is one of the most heated question in interview?
Differences between server.transfer and response.redire ct?
plz send me answer with example -
how to send forms data to email address?
hello friend,
i have a form with data. how to send forms data to email address?
plz. send me the answer? and code for it. -
what is differences between cursor and stored procedure?
hello friend,
plz. send me the answer of this question.
what is differences between cursor and stored procedure? -
What is cursor? How many Types of cursor? how to create each one?
Hello Friend,
can u send me about cursor? i find it most difficult.
What is cursor? How many Types of cursor? how to create each one?
what r the benefit of each cursor? -
mcasaurabhsumit started a topic To Make the row highlighted when we check the check box in DataGrid using Bubbled Evein .NETTo Make the row highlighted when we check the check box in DataGrid using Bubbled Eve
Deletion in DataGrid using Bubbled Event:
lblMsg
Delete empid empname sal address usertype
13 naresh 7000 ratna giri admin
6 pawan 7000 munirka user
7 sanjeev 8000 munirka super user
2 saurabh 2000 mehrauli admin
5 rohan 5000 mahilpur user
1 sumit 1000 ladosarai user
8 ali 9000 katwaria sarai admin
11 bipin 3000 kalkajee user
3 tarun 3000 ganesh nagar... -
How to Delete Duplicate Record in sql server 2000
Hello Friend, I am sumit saurabh. I am doing MCA from IGNOU.
Can you plz. Help me to write a query-------
How to delete duplicate Records from a table using single statement.
Note: one Record should not be deleted out of all duplicated record. -
how to update two table writing only one query?
Hi friend,
can u help me to the question-----how to update two table writing only one query?
because i failed to answer in interview.
wish u all the best -
select top 1 id from emp order by id desc...Leave a comment:
-
How to find last record in sql server 2000?
Hi friend, I am unable to get last record in sql server 2000. How to find last record in sql server 2000? -
how many tables a dataset can store at a time?
hello friend,
how many tables a dataset can store at a time? can u tell me. -
How to get last record in sql server 2000?
Hello friend,
i have difficulty to find out last record in sql server 2000?
could u plz help me?
No activity results to display
Leave a comment: