can any one please send sql quries most used in applications.
Answers were Sorted based on User's Feedback
Answer / guest
select * from employee
where sal =
(select * from max(sal) from emp)
| Is This Answer Correct ? | 3 Yes | 3 No |
What is the difference between referencing and joining?
Difference between LEN() and DATALENGTH() in sql server ?
What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.
If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?
Tell me in brief how sql server enhances scalability of the database system?
What is the purpose of using COLLATE in a query?
What is wide table?
What is a partitioned view?
How to execute a sql statement using odbc_exec()?
What are different types of database indexes?
Does sql server use java?
What is data modeling and Reterminal integrity?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)