database(sql)

Ads
 

database(sql)

Write SQL queries for the following :

  1. Display each employee‚??s name and date of joining.

  2. Display employees earning more than Rs.5,000. Label the column name ‚??Employee‚??.

  3. Display all employee names and employee numbers in the alphabetical order of names.

  4. Display all employee names containing the letter ‚??S‚??.

  5. Display the employees hired in 1981.

  6. Display the minimum and maximum salary.

  7. Display the list of employees along with their department name and its manager.

  8. Display the number of different employees listed for each department.

  9. Delete the records of all the employees hired in 1981 from EMP table.

  10. Update the salary of all the employees to Rs. 10,000.

View Answers

Ads









Related Tutorials/Questions & Answers:
sql database
sql database  how to upload image in website give asp.net code fot that   how to get difference of two date in year in sql database
database(sql)
database(sql)  Write SQL queries for the following : Display each employee‚??s name and date of joining. Display employees earning more than Rs.5,000. Label the column name ‚??Employee‚??. Display all employee names
Advertisements
Transfer Data to Sql Database
Transfer Data to Sql Database  Hey guys, how to Transfer data to SQl database using Java? Transfer data already stored in excel to Sql databse using Java? Looking for an easier method so i can comprehend
Import Data to SQL database in Java
Import Data to SQL database in Java  Hi, I'm a beginner and I'm wondering how to Import Data to SQL database in Java? Thanks (Platform: Eclipse/SQL
SQL Alter Database
SQL Alter Database       SQL Alter Database is used to modify the structure of existing database. Understand with Example The Tutorial illustrate an example from 'SQL Alter Database
Create Database in SQL,SQL Tutorial
Create a database       In this section, we will teach you to create a database.  First of all... database. Then create a database using the given syntax and give the suitable name
Migrating sql database to Access through coding
Migrating sql database to Access through coding  How can i migrate SQL database(table) to My access through coding
ModuleNotFoundError: No module named 'sql-database-service'
ModuleNotFoundError: No module named 'sql-database-service'  Hi...: No module named 'sql-database-service' How to remove the ModuleNotFoundError: No module named 'sql-database-service' error? Thanks   Hi
Uploading a Profile with image[file] into a sql database
Uploading a Profile with image[file] into a sql database  I need to upload a file along with the some text into a database ......[ Similar to http... , but upload file to database ] ... Pls help
SQL database parameters should save at where?
SQL database parameters should save at where?  Hi, Currently the information regarding the SQL databases are hard coded into the script, Assuming the script will be running for very long time, I like to move the SQL database
insert rows from browsed file to sql database
insert rows from browsed file to sql database  i need to insert rows from excel to database by browsing the file in jsp. by connecting both..., content of the file has to go to database. how can i insert record into database
insert and retrive image from sql server database in jsp
insert and retrive image from sql server database in jsp  what is the code to insert and retrive an image from sql server database in jsp
how to connect jsp with sql database by netbeans in a login page?
how to connect jsp with sql database by netbeans in a login page?  how to connect jsp with sql database by netbeans in a login page
how to connect jsp with sql database by netbeans in a login page?
how to connect jsp with sql database by netbeans in a login page?  how to connect jsp with sql database by netbeans in a login page
how to connect jsp with sql database by netbeans in a login page?
how to connect jsp with sql database by netbeans in a login page?  how to connect jsp with sql database by netbeans in a login page
How to insert image in sql database from user using servlet
How to insert image in sql database from user using servlet  pls tell me accept image from user and insert image in sql server 2005 database using servlet and jsp
How to search the table name in MS SQL Database 2005 from application
How to search the table name in MS SQL Database 2005 from application  How to search the table name in MS SQL Database 2005 from application from our helpdesk application? application might be in html
Export SQL database schema from SQL server management studion express2005 into MS excel file
Export SQL database schema from SQL server management studion express2005 into MS excel file  HI I need to export Database Schema from SQL Server.... but i need to have Excel file contains database schema. how can i do with SQL
Need Solution to get vaues from sql database in java
Need Solution to get vaues from sql database in java  hi I have... need to get values from sql database for values in the blank field(" "). how do i get these values.. already connected database and created xml tags in separate
Solution to get vaues for xml tags fform sql database in java
Solution to get vaues for xml tags fform sql database in java  hi I...; now i need to get values from sql database for values in the blank field(" "). how do i get these values.. already connected database and created xml tags
How to find out the friend user between two columns in sql database
How to find out the friend user between two columns in sql database  Hi, Can any one please tell me ..how to find out the friend user between two columns in sql database? In other words i wanted to get the corresponding data from
how to make JTable to add delete and update sql database table
how to make JTable to add delete and update sql database table  Hello all I want to know how to make JTable to act actively to add delete and update database table. i am struck ed here from long time please help me
How to Import mysql database command line, Import MySQL dumpfile, SQL datafile into my database ?
How to Import mysql database command line, Import MySQL dumpfile, SQL datafile... dumpfile, SQL datafile into my database   You can easily restore...://www.phpzag.com/import-mysql-database-command-line-import-mysql-dumpfile-sql-datafile
create,edit and delete in JSP using struts and SQL server2005 as database in jdeveloper?
create,edit and delete in JSP using struts and SQL server2005 as database in jdeveloper?  I have a project ie create an application for users... and SQL server2005 in JDEVELOPER. I have not worked on struts yet.How should i
create,edit and delete in JSP using struts and SQL server2005 as database in jdeveloper?
create,edit and delete in JSP using struts and SQL server2005 as database in jdeveloper?  I have a project ie create an application for users... and SQL server2005 in JDEVELOPER. I have not worked on struts yet.How should i
How to get the most recent data from the sql database
How to get the most recent data from the sql database  Hi, just wanted to show the most recent row from the database table...in my web page. for example if i have four records in the table that was added on different different
what is proper way to save pictures in SQl database and call it through JSP ?
what is proper way to save pictures in SQl database and call it through JSP ?  Hi guys, I usually store picture path in DB and call them through 'getContextPath()' mehtod using this method I can call pictures and Text on same
Insert Data into Database Using Hibernate Native SQL
Insert Data into Database Using Hibernate Native SQL... to insert data into database. Native SQL is handwritten SQL for all database... native sql for inserting data into database. Hibernate Native uses only
SQL Use
the 'SQL Use' we create a database 'komal' using create database keyword... SQL Use       SQL Use Query is used to see the tables in database. Understand with Example
Need solution to get values for XML namespace tags from SQL database in Java
Need solution to get values for XML namespace tags from SQL database... comp:loc=" "/> now i need to get values from sql database for values in the blank field(" "). how do i get these values.. already connected database
How to insert multiple drop down list data in single column in sql database using servlet
How to insert multiple drop down list data in single column in sql database using servlet  i want to insert date of birth of user by using separate drop down list box for year,month and day into dateofbirth column in sql server

Ads