query
Create the following tables and insert 3 appropriate records in each table:
Employee(empid, empname, empstreet, empcity)
Works(empid, companyid, salary)
Locatedin(companycode, compname, compcity)
Find the name of all employees who work for a company located at ââ?¬Ë?Delhiââ?¬â?¢.
Find the address(Street, City) of the employee who get the salary more than the salary of all the employees of ââ?¬Ë?IBMââ?¬â?¢ and working in the company ââ?¬Ë?Oracleââ?¬â?¢.
View Answers
Related Tutorials/Questions & Answers:
query in JDBCquery in JDBC What are the steps required to execute a
query in JDBC
Query conversionQuery conversion can please convert the following mysql
query to hibernate
query
select * from table1 where field1 not in (select field_1 from table3
Advertisements
query optimizationquery optimization hai ! i need a code in java for database
query optimization.plz help
query stringquery string Need some examples of
query strings.send me as soon as possible.
Regards,
R.Santhosh
Query QuestionQuery Question How would I write a
query to display the name, department of the employee that earns the highest salary in the Employees table
HQL QueryHQL Query Hibernate
query language:
How to use a left join in Hibernate
query language. Can somebody help with an example. I am getting a unexpected token error in HQL
Query tool If I use joins
Sql QuerySql Query Is this
query work in Db2 or not ?
Select * from FORUM LIMIT 2
Sql QuerySql Query Is this
query work in Db2 or not ?
Select * from FORUM LIMIT 2
jdbc queryjdbc query write a
query of how to print the values of any column present in database in reverse order
database Querydatabase Query i have to find common columns from two tables fron 2 differnt schemas what
query to use?
i used intersect but i am not getting how it is comapring two tables from different schema because in
query we have
database Querydatabase Query i have to find common columns from two tables from 2 different schemas what
query to use?
i used intersect but i am not getting how it is comparing two tables from different schema because in
query we have
sql querysql query two tables are emp,loc
write a
query to display all the emp information whose locname not equal to bangalore
session into a querysession into a query Hi all this am Sreedhar from Hyderabad
i am calling one session variable in mysql
query but its not working can any one help me please...
here is the
query..
$
query = 'SELECT * FROM post WHERE post_date <
query problemquery problem how write
query in jsp based on mysql table field?
i have employee table it contain designation field, how write
query in jsp... to write this
query in jsp please anybody help me, and send me that code
HQL queryHQL query how to select only password based on username using HQL
query from login table where uname and paswrd are two column names
SQL QuerySQL Query Selecting the third highest salary of Employee without using any subquery?
Here is a
query:
SELECT salary FROM employee ORDER BY salary DESC LIMIT 2,1
query stringquery string on my servlet page i take the values of the field in a variable and that variable is a primary key so on the basis of that i am sorting... servlet page to different servlet jsp page and that i want to do with
query string so
need queryneed query hi sir ,
i am beginner to sql.i need a
query so that it can be helpful to my project.
i have four tables each containing different fruits with different amounts.
i need a
query in such a way that when i say some
Sql QuerySql Query Hi M Navjeet Ghai
I want to know How to Show A name(Like Navjeet Ghai And Manpreet Singh Sodhi) of employees from a employee table as N.Ghai & M.S.Sodhi by using sql
query select queryselect query how to write select
query with where clause having multiple variables. example: i want to select the data from DB in which i want to check againest two variable in where cluase.
String sql = "select * from
SQL QUERY
Gopal oracle C
Now i need to write a
query "which
Query in jspQuery in jsp I have one textbox in jsp. when i will write any letter in that textbox i want all values which are starting from that letter in option from database. same as we are getting in google search textbox.
Thank
dynamic querydynamic query DECLARE
QUERY VARCHAR2(32767);
FIN_
QUERY VARCHAR2...;
PORTFOLIO_LEVEL ARRAY;
IDX NUMBER :=1;
BEGIN
QUERY..._LEVEL;
IDX := IDX + 1;
END IF;
END LOOP;
QUERY :=
QUERY query - SQL tell me how to write the
query in database but not jsp code.
thank u