Skip to toolbar
Forums
 
Notifications
Clear all

SQL Queries Forum
Unread Posts  |  Forums  |  Topics

SQL
Forums
Status
Topics
Forum
Replies
Views
Users
Date 
How to display all the details of employee who is getting 3rd highest salary in employee table.
Topic Tags:  3rdhighestsalary, salaryinemployeetable,
  Interview Questions & Answers
3
1
8 hours ago
8 hours ago
Create View Mysql: Can you help me to create these views using employee table as reference?
Topic Tags:  createviewmysql,
  Other Documents
0
1
2 days ago
2 days ago
What is mean by SQL query formatter? How do we format SQL query?
Topic Tags:  sqlqueryformatter, formatsql, formattingsql,
  Other Documents
1
16
3 days ago
3 days ago
What is SQL query checker? How do we find errors in the query?
Topic Tags:  sql query checker, finderrorsinsql, sqlquerycheckermethod,
  Other Documents
1
14
5 days ago
5 days ago
Can you give some examples using SQL date format dd mm yyyy?
Topic Tags:  sql date format dd mm yyy, sqldateformat, yyyymmdd, dateformatddmmyyyy,
  Other Documents
2
16
VK
6 days ago
6 days ago
How to write a query to count the number of invoices?
Topic Tags:  write a query, count in invoices, count number of invoice,
  Interview Questions & Answers
1
17
VK
6 days ago
6 days ago
Load More Topics
PL SQL
Forums
Status
Topics
Forum
Replies
Views
Users
Date 
How to achieve this complex scenario using PLSQL Procedure?
Topic Tags:  taskstatus, complexplsqlprocedure, plsqlinterview,
  Interview Questions & Answers
2
63
Sep 15
Sep 15
Can you explain little advance topics related plsql like varray nested table bulk collection
Topic Tags:  plsqladvacedtopics, varrynestedtable, bulkcollection,
  Interview Questions & Answers
0
61
Aug 18
Aug 18
Write a PL/SQL procedure to perform withdraw operation that only permits a withdrawal, if there is sufficient funds in the account then update the Account table and print the message, 'Transaction successful.' else print, 'Insufficient Amount'. T...
Topic Tags:  withdrawamountprocedure,
  Interview Questions & Answers
2
63
Rahul Updhyay
Aug 09
Aug 09
Create a program that copies the departments located in 'CBE' to a table called 'DEPARTMENT_CBE. Do not use a cursor FOR loop. Display how many rows where copied else display the message 'No Records found'.
Topic Tags:  copyrecords, proceduretocopyrecords,
  Interview Questions & Answers
3
56
Rahul Updhyay
Aug 09
Aug 09
Create a PL/SQL Trigger to display the message "Re-Order Level reached for the item-item name", whenever a item quantity reaches 10 and below while updating for inserting an item.
Topic Tags:  inventoryalerttrigger,
  Interview Questions & Answers
2
53
Rahul Updhyay
Aug 09
Aug 09
Write a PL SQL to count the locations, where the various departments are located and print the number.
Topic Tags:  procedurecountnumberofloc,
  Interview Questions & Answers
2
36
Rahul Updhyay
Aug 09
Aug 09
Load More Topics
Oracle
Forums
Status
Topics
Forum
Replies
Views
Users
Date 
Can we join view with table in oracle?
Topic Tags:  joinviewwithtable,
  Interview Questions & Answers
2
49
vinodkrsetty
VK
Sep 17
Sep 17
How to find only non matching records from both tables?
Topic Tags:  nonmatchingrecordstwotabl, nonmatchingrowsoracle,
  Interview Questions & Answers
2
97
vinodkrsetty
Sep 03
Sep 03
Find the day name of 2021 new year day from sysdate?
Topic Tags:  nameof2021, newyearday, fromsysdate,
  Interview Questions & Answers
1
35
vinodkrsetty
Jul 30
Jul 30
Find last name of all employees from a full name column?
Topic Tags:  lastnameofallemployees, fullnamecolumn, findlastname,
  Interview Questions & Answers
1
44
vinodkrsetty
Jul 30
Jul 30
How to find profit% from sale amount & purchase amount?
Topic Tags:  profitpercentquery, salesamount, oraclesqlprofitquery, profit%,
  Interview Questions & Answers
1
36
vinodkrsetty
Jul 30
Jul 30
How to get age from dob column?
Topic Tags:  agefromdob, oracleagefromdate, agequeryoracle,
  Interview Questions & Answers
1
61
vinodkrsetty
VK
Jul 27
Jul 27
Load More Topics
Data Warehousing & ERD
Forums
Status
Topics
Forum
Replies
Views
Users
Date 
What is normalization in dbms?
Topic Tags:  normalizationindbms, normalization,
  Interview Questions & Answers
1
27
VK
Sep 17
Sep 17
What are the data cleansing steps?
Topic Tags:  datacleansing, datacleaning,
  Interview Questions & Answers
1
19
Sep 13
Sep 13
What are the top reporting tools in BI?
Topic Tags:  reportingtoolsinbi, reportingtools, bestreportingtools, datawarehousereportingto,
  Other
1
28
Sep 13
Sep 13
What is Star Schema and Snowflake Schema in Data Warehousing?
Topic Tags:  differencebetweenstarsche, starschema, snowflakeschema,
  Interview Questions & Answers
2
79
Sep 02
Sep 02
What is the best ETL tool? What are the important features of ETL tools?
Topic Tags:  etltool, bestetltool, etltoolfeatures, etltoolfunctions,
  Other
1
107
SQL Admin
Sep 01
Sep 01
What is Junk Dimension in Data Warehousing?
Topic Tags:  junkdimension, useofjunkdimension, datawarehousejunkdimensi,
  Interview Questions & Answers
1
78
VK
Aug 30
Aug 30
Load More Topics
Share: