What is a SELECT statement?
A select statement is an SQL statement that retrieves data from a table or view.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
How many ways we can we find the current date using MySQL? 06.11.08
SELECT CURDATE(); SELECT CURRENT_DATE(); SELECT CURTIME(); SELECT CURRENT_TIME();...Why SELECT INTO statement does not work ? 21.07.08
First of all, chect the syntax of your SELECT INTO statement. If the syntax is correct, check that the select into/bulkcopy database option is turned on. To...How you open and close a cursor variable.Why it is required? 11.05.08
OPEN cursor variable FOR SELECT...Statement CLOSE cursor variable In order to associate a cursor variable with a particular SELECT statement OPEN syntax is used...What is a subselect? Is it different from a nested select? 26.03.08
A subselect is a select which works in conjunction with another select. A nested select is a kind of subselect where the inner select passes to the where criter...What is sqlcode -811 ? 18.03.08
SELECT statement has resulted in retrieval of more than one row....What are types of Select statements? 09.04.07
SELECT SINGLE ... WHERE ... SELECT [DISTINCT] ... WHERE ... SELECT * ......How can you create JDBC statements and what are they? 26.10.06
A Statement object is what sends your SQL statement to the DBMS. You simply create a Statement object and then execute it, supplying the appropriate execute met...How could I get distinct entries from a table? 06.08.06
The SELECT statement in conjunction with DISTINCT lets you select a set of distinct values from a table in a database. The values selected from the database tab...What command is used to create a table by copying the structure of another table? 09.03.06
CREATE TABLE .. AS SELECT command Explanation : To copy only the structure, the WHERE clause of the SELECT command should contain a FALSE statement as in the f...What is the difference between a break statement and a continue statement? 07.03.06
A break statement results in the termination of the statement to which it applies (switch, for, do, or while). A continue statement is used to end the current l...