database(sql)

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









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
database - SQL
database  Is there any difference between sql ans mysql?  Hi rahul, Following are some specific technical differences in MySQL and SQL Server, * MySQL does not support Triggers, SQL Server does. * MySQL
database - SQL
database  For ex: Suppose there is 1000 questions (records) in my database. In my home page i want to display everyday 1 question as day of the question.It should not get change until date change...   Hi friend
database - SQL
everyday 1 question as "Question of the day" from database. It should not change
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
DataBase connection with sql - Struts
DataBase connection with sql  How to connect sql and send db error in struts? what are the tag should i code in struts-confic.xml
Database Sql question? - WebSevices
Database Sql question?  Given relation r (a, b,c), show how to use the exstended SQL features to generate a histogram of c versus a, dividing a into 20 equal-sized partions (that is where each partition contains 5 percent
database connection - SQL
database connection  hi friends, This is poornima i want to connect sql server to my eclipse editer how to connect and where i have to write code...-database connection in eclipse IDE? Thanks
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
creation of database - SQL
creation of database  hi, where to and how to execute SQL queries?   Hi nanju mysql>CREATE DATABASE search; mysql> SHOW DATABASES; mysql> USE search mysql>create table Emp (fname VARCHAR(20
Database - mysql - SQL
Database - mysql size limit  What is the size limit for any mysql database
SQL Alter Database
SQL Alter Database       SQL Alter Database is used to modify the structure of existing database... 'SQL Alter Database'. To grasp the example we create a database 'komal' using
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
MySql database - SQL
to retrieve the data from Ms-access then you create a database , table and create a connection with this. Then you retrieve the data from the database. Thanks
Creating Database - SQL
ciao.co.uk. we are creating the database in mysql. 1> category->subcategory->... the database.?   Hi Gurugajanan Read for more information, http
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
SQL Database Analyst
SQL Database Analyst       Position Vacant: SQL Database Analyst Job Description ... with SQL Server Database.  T-SQL  Database
DataBase connectivity in java with Microsoft sql server2000 - JDBC
DataBase connectivity in java with Microsoft sql server2000  How i can achieve database connectivity with Microsoft sql server2000 in my java source code
Database connection sql server 2005 - JDBC
Database connection sql server 2005  Hi all i am developing an application in struts and i need to connect database for that application using sql server 2005.. can anyone tell me how to make database connection ..plz help me
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
delete data from database - SQL
delete data from database  HOw to delete specific data from table> I want to delete one record from database. Thnx  Hi friend, -------------------------------------------- Visit for more information
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
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
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
Help on JDBC and my SQL 5 database - JDBC
Help on JDBC and my SQL 5 database  Dear Sir, I had create... a Jtextfield (txtSearch.getText()) match with mySQL database field... indicate that no such word found in mySQL database or incorrect word. Thanks
database - SQL
database - SQL
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
how to search a word on entire database? - SQL
how to search a word on entire database?  hi, I want to search a word into the entire database.. note: not from particular table.. using php and mysql. any way to find this? thanks in advance
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
Using C# DataGridView to insert record into Microsoft SQL Server 2005 database - SQL
Using C# DataGridView to insert record into Microsoft SQL Server 2005 database  Dear Sir, I am new to Microsoft SQL Server 2005. Currently, i'm creating a sales database system using C# and Microsoft SQL Server 2005. I had
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
To retrieve image from SQL Server Database - Java Server Faces Questions
To retrieve image from SQL Server Database  Sir/Madam, I am trying to retrieve image from SQL Server 2000 database in Visual Web JSF Page using... or in Image Component. please help me in retrieving and displaying image from SQL Server
Retrieve data from database by using sql tag of JSTL SQL library
Retrieve data from database by using sql tag of JSTL SQL library... we will see how retrieve data from database using sql query given by user... of database, url etc.  Attributes of the tag <sql
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
Maven Repository/Dependency: org.eclipse.dirigible | dirigible-database-sql
Maven Repository/Dependency of Group ID org.eclipse.dirigible and Artifact ID dirigible-database-sql. Latest version of org.eclipse.dirigible:dirigible-database-sql dependencies. # Version Release Date
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... how you can use Native SQL with hibernate. You will learn how to use Native to insert data into database. Native SQL is handwritten SQL for all database

Ads