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 |
hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.
What is normalization in Database ?
What does it mean to normalize a database and why would you do it?
What are the different types of upgrades that can be performed in sql server?
What are the different authentication modes in sql server? How can it be changed?
How can you check the version of sql server?
How to name query output columns in ms sql server?
Define tool Manage Statistics in SQL Server 2000 query ?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What is table value parameters (tvp)?
What is Trace flag?
how to get the salary in descending order with out using the keyword desc in sql
Oracle (3253)
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)