Home Discussion Discuss: SQL SELECT DISTINCT Statement

  • Mistake in while Insert ting data in tablePrashanth April 12, 2011 at 2:02 PM

    wrong one : insert into Stu_Table values(1,'Komal',10); insert into Stu_Table values(2,'Ajay',10); insert into Stu_Table values(3,'Rakesh',10); insert into Stu_Table values(3,'Bhanu',10); insert into Stu_Table values(4,'Santosh',10); insert into Stu_Table values(1,'Komal',10); insert into Stu_Table values(2,'Ajay',10); insert into Stu_Table values(3,'Rakesh',10); insert into Stu_Table values(4,'Bhanu',10); insert into Stu_Table values(5,'Santosh',10);

  • wrong articleravindra.p.singh November 24, 2013 at 6:50 PM

    Man from where you have learnt sql,total wrong and useless example.

Post your Comment



Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Related Articles
Programming Tutorials

SQL SELECT DISTINCT Statement
SQL SELECT DISTINCT Statement     ... with the select statement. The SQL Distinct clause is used with the Select statement... The Tutorial illustrates you an example from SQL Select Distinct 

SQL Tutorial

SQL SELECT DISTINCT Statement
SQL SELECT DISTINCT Statement   ... clause with the select statement. The SQL Distinct clause is used with the Select... SQL SELECT DISTINCT Syntax The SQL Distinct clause can be used 

Hibernate Questions

Count distinct value in HQL.
= sessionFactory.openSession(); String countHql = "Select count(distinct salary...)); } } Output: Hibernate: select count(distinct employee0_.salary) as col_0_0... Count distinct value in HQL.  How do you count distinct value in HQL 

SQL Question

mysql select statement - SQL
mysql select statement  i want to select id,name,age values from database.i created the following coding to select values from the table according to the id value which is selected by the user.pls help me select id,name,age from 

SQL Question

Help with SELECT/JOIN statement
a select statement that will return me all rows of t1 but, when t1.id = t2.id, I...Help with SELECT/JOIN statement  I have two tables (t1 and t2... id | name | value ------------------- 2 | lyn | 99 I would like a SQL 

SQL Question

where clause in select statement
where clause in select statement  In Mysql,I write the following query: select * from emp where designation = "MANAGER" But the actual value in the table is "manager" Will the above query retrieve any records? According to me 

Hibernate Tutorial Example

Hibernate Criteria Count Distinct
this application it will display message as shown below: select count(distinct...Hibernate Criteria Count Distinct The Hibernate Criteria count distinct is used to count the number of distinct records in a table. Following a way to use 

Hibernate Tutorial Example

Hibernate Criteria Distinct
Hibernate Criteria Distinct The Hibernate Criteria Distinct API search and display the distinct result Consider the following SQL SELECT DISTINCT name FROM student WHERE roll_no=2; The above SQL will return the  distinct name 

SQL Tutorial

The SELECT statement for SQL
The SELECT statement for SQL       SELECT key word is used to select data from a table.  Syntax:           SELECT column_name(s 

MySQL

MySQL Select Statement
MySQL Select Statement     ... statement in MySQL and you can also learn how to use SELECT statement with WHERE clause. The SELECT statement is used to retrieve the records from the table 

Programming Tutorials

Select Statement in SQL, SQL Tutorial
The SELECT statement for SQL       SELECT key word is used to select data from a table.  Syntax:           SELECT column_name(s 

JDBC Questions

SQL select statement doesn't return any rows,
SQL select statement doesn't return any rows,  When an SQL select statement doesn't return any rows, is an SQLException thrown 

Hibernate Tutorial Example

hibernate criteria Distinct_Root_Entity
hibernate criteria Distinct_Root_Entity In this Tutorial, We will discuss... Restriction  and like condition. The DISTINCT_ROOT_ENTITY field is ensures that each row of results is a distinct instance of the root entity. Here is the simple 

Hibernate Tutorial Example

hibernate criteria Distinct Result Example
hibernate criteria Distinct Result Example In this Example, We will discuss... Restriction  and like condition. The DISTINCT_ROOT_ENTITY field is ensures that each row of results is a distinct instance of the root entity. Here is the simple 

SQL Question

SET and SELECT
SET and SELECT  hello, What is difference between SET & SELECT in sql????   hii, SET : The set statement is used to the update query. SELECT : The select statement is used to display the all data's in the table 

JDBC

JDBC Batch Example With SQL Select Statement
JDBC Batch Example With SQL Select Statement: In this example, we are discuss about SQL select statement with JDBC batch process. We will create SQL... will insert value in these table and then fetch data by using select statement 

JDBC

JDBC Select Statement Example
.style1 { text-align: center; } JDBC Select Statement Example Select Statement retieves the data from single or multiple tables from a database... for getting // connection Statement stmt = null; // Statement reference 

JSP Servlet Questions

Column select
Column select   How i fetch Experience wise resume?   ... or no. Then using the query select * from resumes where experience='yes', fetch all the data...("jdbc:mysql://localhost:3306/test", "root", "root"); String query = "select * from 

Struts Questions

Select from select list + display
Select from select list + display  i have a select list containing... select EmpCode from the select list, the corresponding EmpName and DeptName should...;/div> <tr><td><b>Select:</b></td><td>< 

JDBC

Using Select Statements in JDBC
; The SELECT statement is used to select data from a table. For terminating... then we have to use SELECT statement. The Query can be written as below... with database and execute the Select Statement.   SelectState.java 

Hibernate Questions

how I do select from select in hql
doesn't work select RN from ( select rownum RN, DBId from ( select distinct p...how I do select from select in hql  select RN from ( select rownum RN, dbid from ( select * from profile p where type = 1912 and name like 

Tools For Java Technology

The Switch statement
. To avoid this we can use Switch statements in Java. The switch statement is used to select multiple alternative execution paths. This means it allows any number... of a variable or expression. The switch statement in Java is the best way to test 

JDBC

Select Records Using Prepared Statement
Select Records Using Prepared Statement   ... that the PreparedStatement object  represents a precompiled SQL statement. See brief... problems arises in that process it shows a message "SQL statement 

Programming Tutorials

Use if statement with LOOP statement
Use if statement with LOOP statement       Conditional if statements  in SQL are used... with Example The Tutorial illustrate a example from if statement with LOOP 

Quartz Tutorials

SQL And Statement
SQL AND Statement       The SQL AND operator is used to show you the filter records... with Example The Tutorial illustrates an example from SQL AND Statement 

Java Beginners

prepared statement
prepared statement  plese give me a code that have preparedstatement interface and uses a select query having condition date="s"; where s is the date, but this date parameter passed as the string 

MySQL

Mysql PHP Select
Mysql PHP Select       Mysql PHP is used to execute the select statement using mysql_query...("Error in selecting the database:".mysql_error()); $sql="Select 

Java-Tutorials

JDBC: Select Records using Prepared Statement
the common sql query. Select statement is used to retrieve records from the table...JDBC: Select Records using Prepared Statement In this section, you will learn how to retrieve records of table using Prepared Statement. Select Records  

SQL Question

general syntax for a SELECT statements
general syntax for a SELECT statements  Write down the general syntax for a SELECT statements covering all the options   Hi, The general syntax of a select statement covering all the options is as follows, this syntax 

Hibernate-Tutorials

SQL Select, HQL Select Example, HQL Select Query
HQL Select In this tutorial we will learn how to use HQL Select statement to load the Entity objects. The HQL Select query is used to load Entity based... is the complete example of HQL Select statement: package 

DMCA.com