sql

  1. Pooja Sharma

    Tutorial Classification Of Sql

    SQL is a language that provides an interface to relational database system. SQL was developed by IBM in the 1970 for use and stands for sequential query language. Features of SQL are as mentioned below : SQL can be used by a range of users, including those with little or no programming...
  2. steve taylor

    Help Me/Question What Is Sql Injection?

    There are some weakness are available in the every programming language. SQL have also a some weakness or we can say that illegal use of some command. SQL injection is the technique in which hacker inject SQL commands into an SQL statement to access the database content illegally. How to detect...
  3. steve taylor

    Help Me/Question What Is The Difference Between Union And Union All Sql Syntax?

    With the help of union operation we can combine two sets of similar type. In union operation by default repeated values are eliminated the purpose of the union operation are same in the SQL Query Union operation are used to combine the two or more attributes value of the relation. In which way...
  4. Doominic anderson

    Help Me/Question Write The Sql Query?

    In a table there are some attribute like E-name,E-address,E-salary and E-designation and there are ten employees records stored in the table "Employee" If we want to get all the information about the top three employees who get maximum salary. What is the SQL query to retrieve above information?
  5. Swati Mishra

    Tutorial 10 Best Sql Tips For Developers In 2016

    SQL is structured Query language which is used for the database. Where a user can performs operation on stored database. There are varieties of SQL queries and I am going to write some best 10 SQL tips for developers in 2016. 1. Understand the four fundamental resources A database server...
  6. Doominic anderson

    Help Me/Question How Pl-sql Is Differ From Sql

    Sql is structured query language used to manage the records for database,it is responsible for insertion,updation,alteration,deletion of records in a database. How Pl-Sql is differ from Sql,and what are the advantages of using Pl-sql in Database? And one more doubt,Sql is used by Pl-Sql or...
  7. Swati Mishra

    Tutorial Top 10 Sql Query By Using Functions In Database

    String Function: In the database sql server provide the string function, character expressions are come under the string function. This function is used for the operation on the character strings. String function is also convert data into char or varchar datatype. Syntax is: SELECT...
  8. Swati Mishra

    My 2 Cents What Is The Common Retrieving Sql Query Used For Database?

    Based on pattern matching String operator: For match the specified portion of character string we used the LIKE keyword. The LIKE keyword permits for wildcard characters. These are the wildcard characters are using as an expression .The like operator is not case sensitive. These are the...
  9. Swati Mishra

    Tutorial A Complete Guide To Basics Of Database

    A DBMS (Database Management System) is a combination of hardware and software can be used to set up a database and can update and retrieval of database that has been stored. These are facilities which providing by DBMS: Creating file, addition, deletion, modification of data. Retrieving of...
Top