Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL where clause in select statement
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


dr
where clause in select statement
0 Answer(s)      a year and 11 months ago
Posted in : SQL


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 it should not.But I am getting all records for which designation is "manager".

Please guide why it is happening and help me with this so that I get records nly if the where condition is "manager" and not "MANAGER"


Advertisement
View Answers

Related Tutorials/Questions & Answers:
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... nly if the where condition is "manager" and not "MANAGER
WHERE Statement in SQL
WHERE Clause in SQL        WHERE clause is used with the SELECT keyword. ' Where...; SELECT column FROM table WHERE column operator value
Advertisements
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...; SELECT * FROM Emp WHERE Name LIKE 'R____'; BETWEEN Clause - The BETWEEN
Where clause
Where clause  I have doubt in Where clause .. i got a Employid from...; The WHERE clause is used to filter records.It is used to extract only those records that fulfill a specified criterion. SQL WHERE Syntax: SELECT column
Where and Having clause
Where and Having clause   hii, What is the difference between where and having clause?   hello, WHERE clause is used to impose condition on SELECT statement as well as single row function and is used before GROUP
Where Clause in SQL
Where Clause in SQL       The Where clause in SQL query is used  with the SELECT keyword... is The select query used with where clause, which search the data
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
in a query. WHERE Clause can be used for specifying the search criteria in SELECT...What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?  What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?   Hi
Select Clause in hibernate.
Select Clause in hibernate.  Example of select clause of hibernate
Select Clause in hibernate.
Select Clause in hibernate.  Example of select clause of hibernate
Select Clause in hibernate.
Select Clause in hibernate.  Example of select clause of hibernate
Mysql Where Statement
; statement: The Query  Where Clause returns only those records from table... Mysql Where Statement       Mysql Where Statement is useful when we want to return the records
SQL SELECT DISTINCT Statement
clause with the select statement. The SQL Distinct clause is used with the Select... SQL SELECT DISTINCT Statement   ... SQL SELECT DISTINCT Syntax The SQL Distinct clause can be used
SQL Backup query with where statement
SQL Backup query with where statement   ...; is used to construct a backup table using where clause. The Where Clause...'. create table stu_table_10_backup( select * from stu_table where stu_class
select clause in hibernate
select clause in hibernate  Example of select clause of hibernate?   Select clause is used for selection of records from a database... This is your select clause, picking the employee details as employee name,salary and date
Mysql Date in where clause
Mysql Date in where clause     ... records from table employee1 on the basis of condition specified in WHERE clause... in Where clause. The given Query create table employee1 is used to create a table
JDBC: WHERE Clause Example
of WHERE Clause in JDBC..."); Connection con = null; Statement statement = null...JDBC: WHERE Clause Example In this section, we will discuss how to use WHERE.... WHERE Clause : MySql Where Clause is used to write some condition and data
HQL Where Clause Example
lngInsuranceId='1' Where Clause can be used with or without Select Clause. Here... HQL Where Clause Example       Where Clause is used to limit the results returned from
Using WHERE Clause in JDBC
to the SELECT statement. The WHERE clause searches the specific results by the SELECT statement. Example of WHERE Clause SELECT Name from... Using WHERE Clause in JDBC    Where
Explain the use of the ‘LIKE’ keyword used in the WHERE clause?
Explain the use of the ?LIKE? keyword used in the WHERE clause?   Explain the use of the ?LIKE? keyword used in the WHERE clause
Explain the use of the ‘LIKE’ keyword used in the WHERE clause?
Explain the use of the ?LIKE? keyword used in the WHERE clause?   Explain the use of the ?LIKE? keyword used in the WHERE clause
Hibernate SELECT Clause
Hibernate SELECT Clause In this tutorial you will learn how to use HQL select clause. Use of SELECT clause in hibernate is as same as it used in SQL... example which will demonstrate you how a HQL select clause can be used. To achieve
SQL Aggregate Functions Where Clause
SQL Aggregate Functions Where Clause       SQL Aggregate Functions Where Clause return you the aggregate sum of the records based on the condition specified in Where Clause condition
HAVING Clause in JPQL (Java Persistence Query Language)
with the SELECT statement to filter the records. A HAVING clause restricts... to each group of grouped table, much as a WHERE clause is applied to a select list... HAVING Clause in JPQL (Java Persistence Query Language
Hibernate WHERE Clause
Hibernate WHERE Clause In this tutorial you will learn how to use HQL where clause. Use of WHERE clause in hibernate is as same as it used in SQL... a HQL where clause can be used. To achieve the solution of such problem
JPA Query with where clause and group by function
JPA Query with where clause and group by function  Any thing wrong...;RaBdrRating>) entityManager.createQuery("SELECT activePackage,SUM(duration),SUM(charge),COUNT(activePackage) FROM User WHERE callType = :callType and startDate
SQL Aggregate Functions In Where Clause
SQL Aggregate Functions In Where Clause       SQL Aggregate Function In Where Clause return... specified in the 'Stu_Name'. In order to overcome, we use the WHERE clause
mysql select statement - SQL
patientdetails1 where id=?   Hi chitra, I am sending select...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
Hibernate Select Clause
Hibernate Select Clause       In this lesson we will write example code to select the data from Insurance table using Hibernate Select Clause. The select clause picks up
PHP SQL Query Where Clause
PHP SQL Query Where Clause     ... query with where clause. To understand how to display the result returned ...;, "userName", "Password"), database is selected by mysql_select
SQL Backup query with where statement
SQL Backup query with where statement   ...; is used to construct a backup table using where clause. The Where Clause..._table_10_backup( select * from stu_table where stu_class=10); Stu_Table
SQL SELECT DISTINCT Statement
with the select statement. The SQL Distinct clause is used with the Select statement... SQL SELECT DISTINCT Statement     ...,'Santosh',10); Stu_Table The Select statement return you
 

 

 

DMCA.com